Isolate records with numbers 2

[LakotaMan]

I have a text field in an Access 2003 DB. Many entries are text, and many are just numbers. I need to isolate the records that have only numbers in that field and can't seem to come up with a criteria do it.

I confess I've searched the forum and not found my answer, possibly because I'm not sure how to search for it.

Any help you can give me will be greatly appreciated, as always.

TWD

 

[SkipVought]

Hi,

"Many entries are text, and many are just numbers. "

Actually they are ALL text values. Its just that some of them apparently are text with numeric characters.

How about

where isnumeric([yourfield] = true

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

Hi,

"Many entries are text, and many are just numbers. "

Actually they are ALL text values. Its just that some of them apparently are text with numeric characters.

How about

where isnumeric([yourfield]) = true

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[PHV]

A starting point:
Not Like '*[!0-9]*'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Dontremb]

Ok, I don't have the entire answer. I'll keep looking. But a good starting point MIGHT be this.

In the criteria of a query, you could put,

Like "[A-Z]*"

That way you can at least SEE the separation.

This might not help you, but I'll keep researching.

 

[LakotaMan]

Thanks, PHV and Dontremb, I used your method and got exactly what I wanted.

Stars to both of you.
TWD