Find Records with no numbers

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

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

-----Original Message-----
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


.