How to select specific results and output to report

[sedixon]

I have a literature database that a user can search using a simple search query. The user now wants to be able to select certain records from that query and output them to a report. I've got the query done, and I've got the report. I just don't know how to select certain records from a query to build a report from.

For example, the user searches for literature matching "pollution" in the database. They recieve 50 results in the query, but only want to print out 10 of the records.
Any suggestions?

Thanks for your help!
Sarah

 

[FoxProProgrammer]

I'm certainly no expert on Access reports as I haven't spent much time developing them yet. However, I do know that a report has a Recordsource just like a Form. I'd suggest either setting the Recordsource to the query that produces the records that they want to print, or creating a table with a SELECT.... INTO <table> and using that table as the Recordsource. It seems like either way should work.

dz

 

[sedixon]

Well I can run a report off the original query. The problem is they only want selected results from that query. I don't know how to give them the option to choose which results they want. I need a check box of some sort, but I can't put that on the query.