Multiple query errors

[guyver32]

Hi all,

Resolved the date range issue, thanks, now I have a problem with the query results.
I have a query based upon several other queries that have the StaffID and the linking factor. When I combine some of the queries it works fine, but with others, seemingly those that have no valves or data in the tables, the query brings back no results what so ever.

The queries are running a simple count of records so they have, StaffID input, date range and it counts the records for that staff member within the date range. The second query gives a sum of the count of the first query.
But when I try to combine the queries so that I can produce a report for multiple work areas for audit, I hit problems, is there another, easy way for me to do this, maybe creating a report from invididual query results and only combining them for the report itself.

HELP! Can not attach actual db because of sensitive nature of the information contained, but would be willing to create a like db as sample.

Thanks for any assistance!

 

[Guus2005]

don't know what the error is. you claim there are multiple. start with the first you don't understand.

 

[guyver32]

Sorry for being unclear, it is an error combining multiple queries.

I have approx 10 tables pertaining to different areas of work, all linked by the StaffID table.
I have a query on each table using a linked StaffID table and querying a specific ItemID count for a specific date range.
I then have a query on the query for each table to give me the sum of the count for specified StaffID.

What I want to achieve is a report that asks for 1 staffID (or the * wildcard for all Staff) and a single input of the date range to give me something like:

StaffID: 001
Query 1 Sum: 45
Query 2 Sum: 12
Query 3 Sum: 18
Query 4 Sum: 54
Query 5 Sum: 7
Query 6 Sum: (No Data inputted on table for criteria so no data displayed)
Query 7 Sum: 26
Query 8 Sum: 97

Hope this is more clear, can you help!

 

[Guus2005]

Sorry, but you have to be more specific. Please post the error or the query.