Comparing 2 fields - Not equal to

[jayney36]

Hi to everyone,

I'm new to this site and a fairly novice user of Access.

I'm designing a query to pull fields from 2 tables matching on a unique number. I need to compare 2 of the fields within each row, and if they do not have the same value then I want to display the information.

eg.
URN School Admission_no1 Admission_no2
2201 Camelford Primary 30 30
2202 Falmouth School 40 30
2203 Cambourne Primary 50 50

In the above instance I'd only want Falmouth school displayed becasue the 2 admission numbers do not match. How do I write this into the query?

Any help would be appreciated

Nina x

 

[redneckgeek]

Select *
From YourTable
Where Admission_No1<>Admission_No2

 

[jayney36]

Thanks Red,
That worked a treat!!!