Comparing data in two fields

[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

 

[Michel Walsh]

Hi,



SELECT * FROM somewhere WHERE field1 <> field2



Hoping it may help,
Vanderghast, Access MVP

 

[Dale Fye]

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

 

[Jitt]

Thank you for your response. Yes, this helps!

Take care.

Jitt