Count date/time entries

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

I have been reading this group for a while and have learned very much
helpful information from it. I have a problem I believe to be an easy
one but just can't figure it out.
I need to have a query for a report - the fields are as follows:

Date Field: DateRecd Text Field: Dispatcher
Date/Time Field: TenSeven Date/Time Field: TenEight

A dispatcher will receive a call on a certain date, enter the date and
then his dispatcher name. When he talks to the crews he will enter
the times in the 10-7 or 10-8 fields.
I need to count how many entries are in the 10-7 and 10-8 fields for a
certain date and for that certain dispatcher. Could somebody please
point me in the right direction. Thanks , Lynn
 
SELECT DateRecd, Dispatcher,
Count([10-7]) as [Count10-7],
Count([10-8]) as [Count10-8]
FROM Your Table
GROUP BY DateRecd, Dispatcher

If you want to restrict it to just one dispatcher then add a where clause

SELECT DateRecd, Dispatcher,
Count([10-7]) as [Count10-7],
Count([10-8]) as [Count10-8]
FROM Your Table
WHERE Dispatcher = "James"
GROUP BY DateRecd, Dispatcher
 
Thank you so much for your fast reply, this will help me very much.


SELECT DateRecd, Dispatcher,
Count([10-7]) as [Count10-7],
Count([10-8]) as [Count10-8]
FROM Your Table
GROUP BY DateRecd, Dispatcher

If you want to restrict it to just one dispatcher then add a where clause

SELECT DateRecd, Dispatcher,
Count([10-7]) as [Count10-7],
Count([10-8]) as [Count10-8]
FROM Your Table
WHERE Dispatcher = "James"
GROUP BY DateRecd, Dispatcher
I have been reading this group for a while and have learned very much
helpful information from it. I have a problem I believe to be an easy
one but just can't figure it out.
I need to have a query for a report - the fields are as follows:

Date Field: DateRecd Text Field: Dispatcher
Date/Time Field: TenSeven Date/Time Field: TenEight

A dispatcher will receive a call on a certain date, enter the date and
then his dispatcher name. When he talks to the crews he will enter
the times in the 10-7 or 10-8 fields.
I need to count how many entries are in the 10-7 and 10-8 fields for a
certain date and for that certain dispatcher. Could somebody please
point me in the right direction. Thanks , Lynn
Click to expand...
Click to expand...
 
Back
Top