creating a report in this manner

[Manoj J via AccessMonster.com]

dont know if its possible to do this with Access......because im new to
using Access.
but i have to create a report in a tabular form.

Total No of Jobs 1 Day 2 Days 3
Days
Worker 1

Worker 2

Worker 3

Total

i have tables with details like Name, IDs, Request Date, Closing Dates.....
and many more.

so i need to
1. compute the total number of jobs that each worker has done.
2. 1 Day means (Closing Date - Request Date = 1). that has to be computed.
3. total number of jobs assigned to all the workers.
4. total number of jobs done in day 1, day 2, .....day n.

i have tried alot of things but i have not been able to figure out much.

will really appreciate it if someone can help me with this and please let me
know if anyone wants more details regarding the database.
thank you.

 

[Duane Hookom]

Have you considered a crosstab query to get your results? Are your "days"
columns limited to a specific range?

Do you have some actual table and field names?