Identifying Numeric or Alpha characters in a table

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
 
G

Guest

Take off the double quotes around False. Better yet make it 0 instead of
False again without quotes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5
Find and compare alpha-numeric convention 2
Importing Alpha-Numeric value into Access 3
Using wildcard characters in search 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Delete any record with an alpha in a field 4
Using a Non-Equi Join select records w search term Begin, Middle, 6
Alpha and Numeric in one field 2

Top