Select specific records from a query

[PolarBear]

I am searching for the best method to select a few specific records form a query that can then be used to generate a report based on the few records that were selected from the query.

To better explain: I want to run a query based on selected criteria, then from the query results, I want to be able to further refine the results to generate a report based on the specific records that I want form the general query.

Something similar to a word merge where you can select the specific records that you want from the merge data.

I have been toying with creating a booleen field in the table, then running the query and generate a make table based on the query, then populate the appropriate records in the make table with the (yes/No) for the booleen field, then rerun the make tablequery and generate the desired report based on the (yes/No) field.

There must be a better way to do this? Any suggestions would be appreciated.

Polar Bear

 

[dcx693]

You're not that far off from the simplest method...if you can add a boolean field to your table, then great. Either using table view or a form (much preferred), select the records you want to show in your report. Creat a query that pulls only the selected records from the table. Then base your report on the query you just created.