Question about some criteria language

  • Thread starter Thread starter chesneydevine
  • Start date Start date
C

chesneydevine

Hello,

i found some examples of criteria language online. I don't think it's
correct, if it is, i don't know why it's not working.

I'm looking to pull some records where the number is less than 400.

What I found what

(<400)
if this is correct it's not working it's still pulling records with
the number higher as well.

Any advice?
 
Is the field you are applying the criteria against a text field or a number
field?

"11101" is less than "400"
11101 is not less than 400

The first is a string comparison
The second is a number comparison.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top