Hi,

I have designed an Access Database which has 2 date fields.

I want to create a query which compares date 1 with date 2 and reports if there is more than 1 day difference between them.

Can anyone help me with this?

Thanks

The following information is based on a Table with 2 date fields of Start and End

Create an expression in your query by typing the following informaiton in the field of a blank column

Abs([start]-[end])

and then list a Criteria of >1 for that field

Hope this helps

Note:

I used Start and End dates for the example, but had added the Abs funciton to reture the Absolute Value of the formula, which would allow the start date to be before or after the end date, enabling it to have a 1 day difference in either direction.

Edited March 29, 200620 yr by Scooter513