Counting Date/Time

[Scottie31]

I'm trying to run a query with an expression so that the number of occurances with a date time field are counted but I keep getting an aggregate values error.

Prod 1 Prod 2 Prod 3 Prod 4 Count
Feb 1 12:01 Feb 1 13:56 2

Any help would be appreciated.

 

[FoFa]

Basic SQL is
SELECT Prod1, Prod2, Prod3, Prod4, Count(*)
FROM YourTable
Group By prod1, Prod2, Prod3, Prod4