Report design

[OCM]

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, but I didn't see an option to attach it in this forum.

Thank you in advance,

DD

 

[cghoga]

in your report detail create 2 text fields
make them invisible to the user set visible=No
in one set control source = iif([EligDay]<=10,1,0)
in the other set the control source = iif([EligDay]>10,1,0)
now, sum the columns in your report footer

hope this helps.