Difference Value Fields in a Query 1

[pattyjean]

I have a query that has a preferred email address field and a Home email address field.

I want to query and find only those that have different values in both fields.

Hope this makes sense.

 

[HarleyQuinn]

Something like

Where Preferred<>Home

?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[pattyjean]

thanks--That seemed too easy!! Must be close to Spring Break!

 

[HarleyQuinn]

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[Remou]

Beware of nulls.

 

[HarleyQuinn]

Yes

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.