REPORT OF JOBS PENDING

[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

 

[NevilleT]

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.

 

[OscarE]

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

 

[NevilleT]

There is a video on U Tube that might help.
http://tubtutorials.com/microsoft-access-sorting-grouping-in-reports-online_UXQJjrE7fJU.html It is on sorting and grouping.

Neville Turbit
www.projectperfect.com.au