View Single Post
Old 02-28-2013, 06:45 AM   #4
apr pillai
Newly Registered User
apr pillai's Avatar
Join Date: Jan 2005
Location: India
Posts: 686
Thanks: 3
Thanked 109 Times in 96 Posts
apr pillai will become famous soon enough
Send a message via AIM to apr pillai Send a message via Yahoo to apr pillai Send a message via Skype™ to apr pillai
Re: Union query works but will not filter report.

  1. Create a make-table query using Union Query as Data Source, run it and create the output table, say tblReport.
  2. Design the Report using tblReport as Record Source or if you need further filtering the records from tblReport then create a Select Query and use it as report source.
  3. Open the Report in PrintPreview.

Step 1 & 3 must be repeated every time the report source data changes in the Union Query. Running these two actions manually every time is not advisable.

These two actions (1. opening the make-table Query, 2. Opening the Report) can be put in a macro (sample image of a macro is attached) and run the macro from a Command Button Click Event Procedure on the Form, whenever the report source data changes.

In fact you can put two command buttons on the Form, one for re-running the report through the macro, and another one to open the existing report directly in PrintPreview mode.
Attached Images
File Type: jpg macro_image.jpg (50.8 KB, 55 views)

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
(Learn MS-Access Tips and Tricks)

All responses are based on Access2003/2007
apr pillai is offline   Reply With Quote