Comparing two columns in Access

[ragulan84]

I have to compare columns in MS acces. Please see below the sample

LAST_NEWSLETTER_OPENED_DATE    LAST_LOGIN_DATE
07/21/09                       06/26/09
07/21/09
12/29/09                       12/31/08
12/08/09                       12/15/09

There are hundreds of field in each column. I want to filer out the fields where login date and newsletter opened dates are same. How to do that? Pls help me.

[nico5038]

Just a

SELECT * FROM tblYours WHERE LAST_NEWSLETTER_OPENED = DATE LAST_LOGIN_DATE;

This is really elementary, I would advise you to get a basic SQL book to get an idea of the possibilities.

Nic;o)