Saving all individual records to a single report

  • Thread starter Thread starter aarcorcar via AccessMonster.com
  • Start date Start date
A

aarcorcar via AccessMonster.com

What I have going is i am quering different records in a single setting.
What I want to happen is the easiest way to save the individual results to a
single report. So if I query 25 records in a session I would like to be able
to access that report afterword to be able to review and print. Is this
possible? Please help!

Aaron Z
 
Sure, Aaron,

Design your query as a Make Table query the first time you run it. You will
be prompted to give your new table a name. To add subsequent records, change
the query design to an Append query (don't change the fields, only the query
type) to do the work. Make your report's Record Source the new table, not the
query. When you finish with the report and want to start fresh, simply delete
all the records in hte new table, not the new table itself, and start fresh.

Hope this helps,

Sam
 
It helped so much! Thanks again! I'm sure I will have more questions in the
future!
Aaron
 
Back
Top