not count date fields if the same

[Icky_Joe]

Hi. I am an Access 2007 user with limited query skills. I need to run a query using 2 separate date columns. I would like to not count the records where the dates are the same. Please help.

[John_G]

Hi -

Suppose your date fields are Date_A and Date_B. Set the criteria for Date_A to : <> [Date_B]

But a word of caution - that will (probably) only work if the two date fields do not contain a time component, i.e. they were set using Date() or a form that entered only the date.

HTH

John

[Icky_Joe]

John - thanks so much for taking the time and helping me. Worked perfectly.