By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,451 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

Comparing two columns in Access

P: 1
I have to compare columns in MS acces. Please see below the sample
Expand|Select|Wrap|Line Numbers
  1. LAST_NEWSLETTER_OPENED_DATE    LAST_LOGIN_DATE
  2. 07/21/09                       06/26/09
  3. 07/21/09
  4. 12/29/09                       12/31/08
  5. 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.
Jan 28 '10 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
Just a
Expand|Select|Wrap|Line Numbers
  1. 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)
Jan 28 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.