Query to match dates in two fields

[shoggy]

Hi,

I'm trying to create a query which will match dates in two fields. Example I have Date Opened and Date Resolved. I want the query to return all fields which have the same Date Opened and Date Resolved. When I run at present I get nothing because there is a time attached to both dates.

Thanks



Shoggy

[JoeM]

There are a number of ways of doing this. In Excel and Access, dates are actually stored as numbers (the number of days since 1/1/1900). So time represents a fraction of a day, and would be stored as decimal.
So one way to remove the time component is to apply the INT (integer) function to the date, which removes the decimal (time portion).

So in your Criteria of your query, something like this would work:

WHERE INT([Date1])=INT([Date2])

[shoggy]

Thankyou very much. Works perfectly