Two Dates the same in two colums

[phillbaker]

i have a query and i want it to not show the results if the dates are the same in two columns.

 

[PaulJR]

How about this:

Create a duplicates query on the date.

Then create an unmatched query and join the date in your table to the date in your duplicate query.

 

[PaulJR]

opps sorry my mistake, I failed to see you said 2 different columns, try this:

1) Create a query and insert the same table in twice.

2) Join the 2 different dates from each table.

3) Select 'Totals' and save the query as DuplicateDates.

4) Then create a new 'Unmatched Query' to compare one of the dates in your table to the date in your DuplicateDates query.

 

[Brianwarnock]

i have a query and i want it to not show the results if the dates are the same in two columns.

Do you mean two columns in the same row?

If so Where daterow1<>daterow2

Brian