Find Records with no numbers

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

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
 
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
 
Back
Top