Date expanding?

[tylerg11]

I want my query date field to only be in short date format. This is because if I try to filter for all records for a certain date, it will also include the time (since that is what was stored in the table), and include the time in the filter. I want to use this query to "trim out" the time so only the date part comes through as the query data. I set the format to Short Date, but this still happens when I click on the field. Why is this??

[alansidman]

In a new field in your query create an expression Int(YourDateField). Because dates are recorded in Access as numbers with the integer part representing the date and the decimal part representing the time, this will then give you only the date portion of the field. Use this new field to filter your query for dates.