Integer Query

  • Thread starter Thread starter Fred W
  • Start date Start date
F

Fred W

I am trying to create a query that will return values that
do not contain any letters.

Thank you,

Fred
 
Try

Not Like "*?*

as the criteria (and check the Help files for details on Wildcards



----- Fred W wrote: ----

I am trying to create a query that will return values that
do not contain any letters.

Thank you

Fre
 
Since "1" is a valid character, I think you might need to change this to

Not Like "*[A-Z]*"
 
You must log in or register to reply here.

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

Checking if data exists another table and, if yes, extracting a value 0
Total appointments per agent 2
Help with DMin? 2
Query Question 2
compute, assign and total values in a query? 4
Query Returning Multiple Results 1
Query returns no records problem 4
Can a query do this? 3

Back
Top