Thanks for the great advice Peter I am working on a query to head in the path you suggest I have so far managed to grab the data I need from two columns and sort is using the IIF function so I think that may get me started I need to find a way now to add a date range to my query and only grab the work orders completed in that date range while holding on to the work orders still in progress that way I can produce a subsequent monthly reports I know its another expression to keep it just have to keep banging away at it thanks again for your advice it helped put me on the right path.
Bill -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Groman (peter.groman) Sent: Wednesday, May 21, 2008 10:55 AM To: [email protected] Subject: RE: [ms_access] Reports and Queries 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] ------------------------------------ Yahoo! Groups Links
