Multiple Criteria Query

  • Thread starter Thread starter jose
  • Start date Start date
J

jose

Hello,

I have a simple database that is used as a call management system for
after hours work. It is used when employees are called after hours
and records the following information in a table called CallData:

Employee Name
Date
Time
Availability (A combo box on the form gives the options of
"AVAIL","U/A","N/A")

Each time a call is made to an employee, a record is made. What I
need to be able to do is to prepare a query that will show: An
employees name, how many times they have been called, and out of the
number of times they were called, how many times they were available,
unavailable, and when there was no answer. I then need to be able to
put this into a report. If it is possible I also need to be able to
run this query on different date intervals (ie) the year of 2003. I
wrote some SQL but all its was able to do was say how many times an
employee was called in total. Does anyone have any ideas on how I can
make this work. Any help would be greatly appreciated.
 
You can create a crosstab query where the Employee Name is the Row Heading,
Availability is the Column Heading and Count(Date) is the value. You can set
a criteria like other queries however you must select Query|Parameters and
enter your parameters and data types.
 
Back
Top