Multiple queries on a single report? 1

[CMooreJr]

hey all! I have a problem I need help with. My Director wants a report that has 3 parts. She wants:

1) Projects that are "New" the week of X
(This needs the project number and project name)

2) Projects that are "In Development" the week of X
(Just the count of these projects.)

3) Projects that are "Complete" the week of X
(This needs the project number and project name)

My form has all necessary fields of course, a cbobox with New, In Development, etc, a date field for New projects, a date field for completed projects, etc. Now, I can figure it out with a query but it will take me 3 queries to sort this info in this manner. Is there any other way to do this? You can't have multiple queries on a single report can you?

 

[randysmid]

Hi,
You can do sorting and grouping based on these project status fields, can't you? In addition, I wrote an FAQ on how to pass criteria (date range) to a query, and the query then becomes the recordsource for the report. Here is the FAQ: faq703-2696
Considering that you want a range of dates, your form will have two text boxes that are designed to allow the user to enter begin and end dates. Your query will have code something like this (belongs in the criteria line for the date field):
Between [Forms]![frmReport]![cmbDateFrom] And [Forms]![frmReport]![cmbDateTo]
Remember to replace "frmReport" with your form name, and replace the text box fields with the names from your form. HTH,
Randy Smith
California Teachers Association

 

[CMooreJr]

aah...I completely overlooked sorting and grouping at that level.....I was thinking to hard! Thanks! Star for ya!