How do I group on first 10 characters in a date/time field in a qu

C

Colleen Thomas

I am extracting data stored in a sequel table. The field I am wanting to
group on the date is a date/time field. How do I group on only the first 10
characters (the date) and ignore the time?
 
D

Duane Hookom

You should refer to "characters" with date/time fields. You might need to
use
DateValue([DateTimeField])
 
Top