I am querying an Access database form excel, however one of the fields in the
db contains both date and time elments - I want to know if there is a way to
trim out the time portion of the field in query so that I only have to
referesh rather than edit all the time.

Tia

Jonathan