J
Joe Spenceley
Hi,
I have a field which is general date and contains dd//mm/yy hh:mm:ss.
I want to count number of records for each date.
e.g. something like
SELECT Count(Messages.MessageID) AS CountMessage, Messages.DateStamp
FROM Messages
GROUP BY Messages.DateStamp;
This groups by the time rather than the date. I've looked at using DatePart
to construct a query but that is looking rather clumsy. Is there a more
efficient way of doing this?
Cheers,
Joe
I have a field which is general date and contains dd//mm/yy hh:mm:ss.
I want to count number of records for each date.
e.g. something like
SELECT Count(Messages.MessageID) AS CountMessage, Messages.DateStamp
FROM Messages
GROUP BY Messages.DateStamp;
This groups by the time rather than the date. I've looked at using DatePart
to construct a query but that is looking rather clumsy. Is there a more
efficient way of doing this?
Cheers,
Joe