Two date fields in one table - Must compare values

[marydn]

I have one table with two date fields. I need to pull all data from the table where the two date fields are equal. Is there any quick and simple way to do this? I have 130K records.

Thanks!!!!!!

 

[jhall156]

In QUERY DESIGNER, type in SQL as follows:

SELECT * FROM <tablegoeshere> WHERE <datefield1goeshere> = <datefield2goeshere>

 

[marydn]

Thanks! It doesn't get much easier than that!