You can not give a report more than one source object (which can be a query or table). But you can get combines data from 2 sources in several ways: (1) write a new query that gathers both sets of info and marks each set in a new "flag column" which you sort on. (2) If the original 2 queries already have a field that you can sort on then you can just write a union query to pull in both data sets (3) Put a sub report in the main report footer that uses the second query as the source object.
- Pete -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill MacDonald Sent: Tuesday, May 20, 2008 5:11 PM To: [email protected] Subject: [ms_access] Reports and Queries Hello All have a noobie question is it possible to create a report that will get data from 2 queries and sort them by query ? I need to provide a monthly report on work orders completed for the month and what ones are outstanding listing the completed ones first any ideas thanks in advance Bill [Non-text portions of this message have been removed]
