Inter-Query Selection

[mschmehl]

Perhaps I'm framing this question improperly, but in a nutshell, I want my query to yield some overall results PLUS a selected segment of those overall results.



I run Year-To-Date (YTD) reports on the Straight-Time (ST) hours and Over-Time (OT) hours of a plant from our Payroll system, export to EXCEL, then import to ACCESS as a table. My query takes this table, then extracts all the ST hours and OT hours by departments. This query is then used as the Record Source for an ACCESS report.

Now, in addition to YTD results, I need results of the latest full month. My basic table of hours data includes the month as a number. What I want the query to do is take the YTD results, and extract another set of results based on a given month.

The above would be the cleanest way, though I've nearly given up trying to figure it out, and am about ready to have two separate queries feeding a single report; though I'm sure there may be challenges for me there too! ;-)

Anyone have any ideas? I'd be glad to supply a sample table with my current query and report if that would help.

Thanks! Michael

[kennejd]

You can post your db....but there's nothing wrong with having 2 queries feeding a single report (perhaps with subreports for YTD and MTD info). You might also consider a union query.