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.