How can I add criteria of 2 fields not matching on a query

[Guest]

I need to return results where 2 fields do not equal each other.

 

[Guest]

Try this

SELECT TableName.*
FROM TableName
WHERE Field1<>[Field2]

 

[Van T. Dinh]

Please do not multipost the same question in different newsgroups.

Please see http://www.mvps.org/access/netiquette.htm

 

[Guest]

Hi Ofer

The fields are indifferent tables which is causing me a problem. Where can
I add this text, is it within design view, query, data definition?

The example I am using is that i have items with qty's that I want to
compare from different tables.

Thanks

Try this

SELECT TableName.*
FROM TableName
WHERE Field1<>[Field2]

--
\\// Live Long and Prosper \\//

I need to return results where 2 fields do not equal each other.

 

[Guest]

How do you join this tables?
Is there a field that you can search on, in all the tables?

Hi Ofer

The fields are indifferent tables which is causing me a problem. Where can
I add this text, is it within design view, query, data definition?

The example I am using is that i have items with qty's that I want to
compare from different tables.

Thanks

Try this

SELECT TableName.*
FROM TableName
WHERE Field1<>[Field2]

--
\\// Live Long and Prosper \\//

I need to return results where 2 fields do not equal each other.

 

[Guest]

The tables are joined by fields that hold the same data but have different
names, relationship is where both are equal.

Thanks

How do you join this tables?
Is there a field that you can search on, in all the tables?

Hi Ofer

The fields are indifferent tables which is causing me a problem. Where can
I add this text, is it within design view, query, data definition?

The example I am using is that i have items with qty's that I want to
compare from different tables.

Thanks

Try this

SELECT TableName.*
FROM TableName
WHERE Field1<>[Field2]

--
\\// Live Long and Prosper \\//


:

I need to return results where 2 fields do not equal each other.