Parsing Data Into Multiple Fields

[JeffGeorge]

I have tables that are ODBC linked to a SQL database. The source tables have record date and time stamps written into one field. This means that I can't use the Access date filter functions on these fields. Is there an easy way to parse this field into two fields, one each for the date and time?

[JoeM]

You can use the DateValue function to pull just the date piece out of a date/time variable.

[JeffGeorge]

Would I do that as part of a query?

[JoeM]

Yes. And then you can filter on that calculated field.

DateOnlyPiece: DateValue([MyDateField])