REPORT OF JOBS PENDING

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

OKY

I'm not an expert but I need to create a DB for technicians in my company. I
have 4 tables named, schedules, techs, timeframe and status.
In a form I choose the tech name , type a job #, and choose a
timeframe(8-11am, 11-2pm, etc). Once the technician completes his job, then I
choose: blank, Done or other from a drop down. I need to create a report and
email it several times a day using this data.
My boss wants to know who has not completed their jobs sort by technician
name. In other words those technician that under STATUS has a blank means
they are not done.
the report will look something like this:
********************************************************
TECH NAME TIMEFRAME TOTAL JOBS OPEN
LUIS 11 - 2PM 2
2 - 5PM 1
8 - 11am 4

Mike 8 - 11am 1
2- 5pm 3
*******************************************************
in that example it tells me that Mike has 1 jobe pending from 8-11am and 3
jobs from 2-5pm pending.

Is this possible to accomplish?
Please help me


thank you
 
Hi Oky

A simple way is to create a report where the query reports on all jobs
outstanding sorted by technician and then by time period. Create a report
where the detail section is for each job and there is a group header for
period, and one for technician. You can then use a total in the group header
or footer to describe the number of records. Once it all works set the
detail section visible property to false and you have your report.
 
Thanks, It sounds simple but remember I am a newby with access. If you could
be specific and provide me the steps I'll appreciate it...
 
Back
Top