If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Saving all individual records to a single report
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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200606/1 |
#2
|
|||
|
|||
Saving all individual records to a single report
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 aarcorcar wrote: 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 -- Sam Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200606/1 |
#3
|
|||
|
|||
Saving all individual records to a single report
It helped so much! Thanks again! I'm sure I will have more questions in the
future! Aaron -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200606/1 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Print Report from Form | AccessHelp | Setting Up & Running Reports | 11 | April 21st, 2006 02:14 PM |
Query Corrupting Results??? | Daniel | Running & Setting Up Queries | 6 | April 17th, 2006 02:29 AM |
Parameter thru Form Dialog Box for REPORT | Sandy | Setting Up & Running Reports | 16 | January 10th, 2006 10:06 AM |
Summarizing records in one table that match a different table | TomC | Setting Up & Running Reports | 16 | December 30th, 2005 03:29 AM |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |