PC Review

Thread Tools Rate Thread

Create a report using multiple queries

Posts: n/a
      4th May 2006
I generate reports by combining 4 queries into a worksheet. I listed them
Q1, Q2, Q3 & Q4 by using the 'insert entire rows for new data, clear unused
cells'. The number of records by each query changes. I'm left with empty
rows, records overlapping, and old data left over from a previous report each
time a generate a new report.

I wish to automate the process by selecting the parameter, clearing the old
data, combine the four queries into one list, sort two columns and print.
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Using queries from multiple tables to create a report Jeff Boyce Microsoft Access Queries 0 5th Dec 2008 08:54 PM
How to create a report based on multiple queries davidstevans@gmail.com Microsoft Access 3 29th Aug 2007 08:45 PM
Report help - using multiple queries to create report anitra_tanner@yahoo.com Microsoft Access Reports 0 8th Feb 2006 10:12 PM
How to create a report based on multiple queries in Access%3f =?Utf-8?B?Q2xhaXJl?= Microsoft Access Reports 1 24th Sep 2004 07:42 PM
Create a single report based on multiple queries Frank Timmons Jr Microsoft Access Reports 2 17th Dec 2003 04:25 AM




All times are GMT +1. The time now is 04:31 PM.