roxannep
Technical User
- Jun 20, 2000
- 69
I have a query with a record summary by title. My boss would like to have a box to click on the left side of the list and then have it pull only one record of that title into a new table for export to Excel.
Example: My query results would look like:
[tt]
DENOM TITLE COST COUNT
$1 Silver mark $2 18
$2 Gold Eagle $10 2
[/tt]
So, if he clicks on a check box on the left, he wants to pull only 1 of each record by title into a new table. I tried adding a "selector" field, but of course it doesn't allow changes in the query mode because of the "count" field.
What would be the best approach to this?
Thanks in advance for your help!
Example: My query results would look like:
[tt]
DENOM TITLE COST COUNT
$1 Silver mark $2 18
$2 Gold Eagle $10 2
[/tt]
So, if he clicks on a check box on the left, he wants to pull only 1 of each record by title into a new table. I tried adding a "selector" field, but of course it doesn't allow changes in the query mode because of the "count" field.
What would be the best approach to this?
Thanks in advance for your help!