Query between two fields

[dr223]

Hallo,

I have a table with two fields A1 and A2. Both of these feilds contain text such A1- MA Psychology and A2 - MA in Psychology.

If you notice A2 has an "in" word in between MA and Psychology. I want to write a query where by only if A1 <> A2, then the fields are brought forward i.e., A1 and A2 will be displayed only if A1<> A2, as for the above example.

Any help will be appreciated.

Thank you very much

This is quite basic!!!

Regards

 

[pbaldy]

You've already answered it:

SELECT...WHERE A1 <> A2

 

[dr223]

so in the criteria part, I will type


Select from sess_0607 (table name) where A1 <> A2

 

[pbaldy]

No; in design view put this in the criteria of A1:

<> A2

 

[dr223]

In the design view, in the criteria section I typed <> A2, Access automatically makes it <> "A2" and still brings all the records even when A1 = A2

Thanks

 

[pbaldy]

If that's actually the field name, try

<> [A2]

 

[dr223]

Thanks worked