Compare 2 values from fields on a table

[browny]

Hi there

This is probably quite easy but I cannot make it work so would appreciate some help. I have a table containing vehicle information. I have 2 fields, Current Mileage and Max Mileage. I want to do a comparison of the 2 fields and should the Current Mileage be greater than the Max Mileage, the query returns the Vehicle Registration. Test data has been entered in the table I am querying and I was expecting 1 value to be returned. However the query as I wrote returned either all the vehicle Registrations or none of them. Can someone help with this please.

Thanks in advance for the assistance
Craig

 

[ColinEssex]

If you make a query and have the [CurMile] and [MaxMile] fields and the reggie number in the query grid.

Then in the criteria of the [CurMile] field put >[MaxMile] this will give you all the records where the [CurMile] is greater than the [MaxMile]

Col

 

[browny]

Hi Colin

Thank you very much, knew it would be simple, works like a dream.

Craig