Testing for numeric

[GraeagleBill]

In the query below, I'm wanting to limit the query to where the "text" field is numeric. E.g., 1203. What you see coded in the screenshot does not work. Any ideas?

[Bob Fitz]

Just IsNumeric should work

[GraeagleBill]

That's what I started with, but query editor wrapped it in quotes so the query was processing the string "IsNumeric" as the criteria.

[CJ_London]

put isnumeric([ChkNo]) in a new column on the field row
untick the show box
put true in the criteria

[GraeagleBill]

OUTSTANDING Ajax! In the middle of the night it occurred to me to try editing the SQL as :

SELECT MemID, [FirstName] & " " & [Lastname] AS Name, DOPmt, ChkNo, CYP, Selected FROM tblMembers WHERE (((Selected)="►") AND ((IsNumeric([ChkNo]))=True));

which worked perfectly and is exactly what you suggested I try via the design view.

As usual, you're a winner.
Thanks,
Bill