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

Comparing fields in same table

P: n/a
Hi All

I want to create a filter that will detect whether I have the same value in
say field 3 and field 4. Could you please tell me how to do this?

Thanks

Cydernet
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Sorry its a Query that I want to create.
"cyder" <cy*******@hotmail.com> wrote in message
news:bt**********@news.pipemedia.net...
Hi All

I want to create a filter that will detect whether I have the same value in say field 3 and field 4. Could you please tell me how to do this?

Thanks

Cydernet

Nov 12 '05 #2

P: n/a
"cyder" wrote
I want to create a <query> that will detect
whether I have the same value in
say field 3 and field 4.


In the Query Builder, choose your Table as the data source, and pull down
into the grid the fields of interest to you (likely the unique id fields of
the record will be important), and at least one of the two fields that
should be equal, then in the Criteria line under that field that should be
equal, enter an equal sign and the name of the other field to be tested for
equality.

In its simplest form, with the table names and excess parentheses removed,
its SQL is going to look something like this:

SELECT RecordID, Field3, Field4
FROM tblSomeTable
WHERE [Field4])=[Field3];

Larry Linson
Microsoft Access MVP

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.