Query Criteria

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

Guest

I need a criteria formula to list all numbers from a table smaller that 1.
Can any one help?
 
Open a new query.
Add the table.
Add the field that has the numbers.
Add any other fields you wish to see.

In the "Criteria" row under your "numbers" field, put:
<1

Run the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
???
Field: yourNumberField
Criteria: < 1

IF that is not what you want then you might want to post a more detailed
description and perhaps a few values that you do want and some you don't
want and identify which of those you would expect to see returned.
 
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

Access Dcount (multiple criteria) 3
Use In() Expression as Query criteria with guts from Function 1
Excel Need Countifs Formula Help 0
search multiple criteria 0
All-Record criteria in a query...hmmm 4
VBA: How can I use a string variable as autofilter criteria? 4
criteria on form 1
Query twice with the same criteria ==> 6

Back
Top