counting query records

[Manoj J via AccessMonster.com]

i 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.

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

1. Use a cross-tab query (aka Pivot Table query).
2. For the PIVOT clause use PIVOT ([Closing Date] - [Request Date]).
3. Use a COUNT() function in the SELECT clause:
SELECT Count(jobs) As [Total No of Jobs] ...
4. see 1.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSQ+RZYechKqOuFEgEQLJ2ACgzu1gepWDPAENyNqiQZKgKNVtb5UAoMrO
m3BwT6zq1jtg5FJObLQXTlm5
=L1nf
-----END PGP SIGNATURE-----

 

[Manoj J via AccessMonster.com]

ohh man !
you've described that in a very professional way.
im going to try what you have suggested but i shall post my doubts here.

thanks.