criteria in a query 1

[joeythelips]

Hi,

I run a query in access which return a list of 9 digit numbers e.g 338098761
What i want to do is prevent numbers which have the digit 4 as their third last digit. e.g 338098401

Any ideas?

Thanks for your time

 

[tlbroadbent]

Select * From Table
Where Mid(Format(TheNumber),7,1) <> &quot;4&quot; Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.