Count date/time entries

[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

 

[John Spencer (MVP)]

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

 

[Lynn]

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