report of blank fields

  • Thread starter Thread starter OKY
  • Start date Start date
O

OKY

I hope I can explain myself with this situation. I have a table where I keep
track of jobs completed by our technicians.
The fields are:
ID DATE TECH JOB# TIME HHC SATUS NOTES
22 06/30/09 13-MIKE 1R 8-11am CP
23 06/30/09 1-NUGO 4R 8-11am
24 06/30/09 13-MIKE 6R 2-4pm
26 06/30/09 1-NUGO 5R 2-5pm
25 06/30/09 1-NUGO 7R 8-11AM
21 06/30/09 1-NUGO 9R 2-5pm
I need to create a report so that only display those jobs that do not have
any text field under "STATUS", in this particular case the report will look
something like this:
==============================================
TECH TIME #OF JOBS PENDING
1-NUGO 8-11AM 2
2-5PM 2
13-MIKE 2-4PM 1
===========================================
sO THE REPORTS ONLY SHOWS RECORDS OF JOBS NOT DONE WHICH STATUS IS SET IN
TABLE "SCHEDULE"
Thank you for your help. Pls be patient , I'm not an expert in access.
The link for my DB is @:


http://cid-515b3cfce2772b8a.skydrive.live.com/self.aspx/.Public/access files/rab.mdb

you can email it back to me at (e-mail address removed) . thanks again!
 
SELECT ID, DATE, TECH, TIME, Count([ID]) AS [#OF JOBS PENDING]
FROM YourTable
WHERE STATUS Is Null
GROUP BY ID, DATE, TECH, TIME;
 
Back
Top