Identifying Numeric or Alpha characters in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a text file I just imported. There are clearly some donor records
that are bad (based on the [Gift_Amount] field having alpha characters in it
after I do the import.

I tried using

isNumeric([Donors]![Gift_Amount])="False"

as the WHERE criteria of a query off the Donor table. It didn't work.

Can someone advise how to identify numeric and identify alpha characters in
an Access table in which the field in question is a Text data type?

Thanks,

Patrick Briggs,
Pasadena, CA
 
Take off the double quotes around False. Better yet make it 0 instead of
False again without quotes.
 
Back
Top