Group by Date that is a timeStamp

[mlocurci]

I want to have a GroupBy query but the format of the date in the table is a timestamp. How do I correctly perform a GroupBy?

 

[lupins46]

Do you mean a SQL Server timestamp or do you mean its an Access DateTime field. In either case why is it a problem?

 

[mlocurci]

Its an access DateTime field. When a do the groupBy it groups by date and time and gives a count of 1 for each item.

 

[lupins46]

So what are you wanting it to do?

 

[mlocurci]

Group by just the date

1/1/05 5
1/2/05 10
1/3/05 12

Ignore the time.

 

[PHV]

If you want to group by day:
GROUP BY Int([your DateTime field])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886