Find Records with no numbers

[Jimmy]

Hello, I have a 45.000 record table with a field that has addresses, (street
name and street number). In my country we write the address in the format:
Address name and then address number, for example "Rhodos 59". I need to
know in which records there is no number after the street name. I filter my
table by city (City is another field) and I need to know in that city which
records have no street number.
Can someone help?
Than you
Jimmy

 

[Chris Nebinger]

How detailed do you want to be?

The easiest way is just to take the last character of the
address and see if it's numeric:

IsNumeric(Right(Trim([AddressField]),1))

Chris Nebinger