filter time (1 Viewer)

[jerry28ph]

I have table name logtime, how can I filter the same date and time log and count it as 1 activity in query. Below is a sample, for 7/3/2009 9:55 count as 1, 7/3/2009 10:42 count as 1, 7/3/2009 8:23 count as 1 and so on. In total, i have only 9 call activity. All log time activity that logs more than 1 will count only 1 activity. Please help how to write the query to get the total 9 activity.

7/3/2009 9:55 7/3/2009 9:55 7/3/2009 10:42 7/3/2009 8:23 7/3/2009 8:44 7/3/2009 8:45 7/3/2009 9:33 7/3/2009 15:47 7/3/2009 14:29 7/3/2009 14:24 7/3/2009 14:24 Thanks.

Jer

 

[Galaxiom]

Make a query in design mode. Right click on the grid and turn on Totals.
Add the logtime field twice.
Set one Totals field as GROUP BY
Set the other as COUNT