Date/time value 2

[knowgeek]

I've imported a .csv file, which has date and time as one field value. When I run a query to group by date the data is not group... Thinking it is due to the unique data/time value. I’ve played w/ format input mask, and validation rules.
Any suggestions...

 

[easyit]

..is the field of your table of the date type? And is the file imported or linked?

 

[knowgeek]

Yes,, short date and it is imported... using access 2003

 

[easyit]

Ok,

than what is your precise question?

 

[JerryKlmns]

I think it is about a query

Select Field1, ... Format(DateField, "dd/mm/yyyy")
From myTable
Group By Field1, Format(DateField, "dd/mm/yyyy");

of course you could update the field to hold only the date part

Update myTable
Set DateField=Int([DateField])

There is a special forum701 for queries...