Comparing data in two fields

  • Thread starter Thread starter jitt
  • Start date Start date
J

jitt

Hi,

I was wondering if it's possible to look at data in two
fields and compare if they are the same or not. I want to
create an exception query to display only those records
where the data in the two fields are different. Is this
possible to do with Access 2000? For example:

Field1 Field2
100 100
20 20
5 10

So display only the third row.

Thanks!

Jitt
 
Hi,



SELECT * FROM somewhere WHERE field1 <> field2



Hoping it may help,
Vanderghast, Access MVP
 
Why would you want 2 fields to contain the same data in the same
record?

SELECT T.*
FROM yourTable
WHERE [Field1] <> [Field2]

--
HTH

Dale Fye


Hi,

I was wondering if it's possible to look at data in two
fields and compare if they are the same or not. I want to
create an exception query to display only those records
where the data in the two fields are different. Is this
possible to do with Access 2000? For example:

Field1 Field2
100 100
20 20
5 10

So display only the third row.

Thanks!

Jitt
 
Back
Top