Report design

[Danny]

I have designed a workers productivity report using Acc 2K which is based on a query and the query is based on one table (all the fields I need Workers, EligDays...etc. are in the same table.
Each worker has 10 business days to process the application. The way it's determine is I have a field called EligDays, which is a result of a calculation field. For example, let's say for worker name Tammy EligDay = 9 then Tammy process the application within 10 business days (<=10) and Tammy process two more applications over and EligDays = 11 & EligDays = 12 then Tammy process two applications over 10 business days (>10).
1. I want the report to show Tammy <=10 = 1
Tammy >10 = 2
Total For Tammy = 3
2. How can I force the report to show both <= 10 and >10 for each worker, even if there is no data..
I have a sample report in Excel/word format, which will show you how the report should look like.
Please let me know how to e-mail you the attachment!

Thank you in advance,

DD

 

[Fornatian]

If I am reading your question correctly, you need 3 queries.

Query 1: Grouped by Person, Summing how many are processed within 10 days suchas

SELECT tblProcessExample.AName, "<10" AS t, Count(tblProcessExample.AName) AS CountOfAName
FROM tblProcessExample
WHERE (((tblProcessExample.ProcessDays)<=10))
GROUP BY tblProcessExample.AName, "<=10";

Query 2: Grouped by Person, Summing how many are processed outside 10 days suchas

SELECT tblProcessExample.AName, ">10" AS t, Count(tblProcessExample.AName) AS CountOfAName
FROM tblProcessExample
WHERE (((tblProcessExample.ProcessDays)>10))
GROUP BY tblProcessExample.AName, ">10";

Query 3: A UNION query pulling the two together:

SELECT * from QRY1 UNION SELECT * from QRY2;

Note that union queries must be typed directly into the SQL query builder.

Now base your report on the resultant union query.