> 0

  • Thread starter Thread starter Gee
  • Start date Start date
G

Gee

I've got a query where it is supposed to return all
records where the Deadline is greater than 0. (Under
deadline is a negative number, over is positive) What I'm
getting is everything BUT 0, as in I'll get records that
have 1, 2, -9, -22...see, I don't know why I'm getting
negatives if I'm asking for >0.
The criteria looks like this:
[Overdue/Under-Deadline Days]>"0"
What am I doing wrong?
Thanks in advance for your help.
 
Gee,

From the looks of your criteria I'd say the field is set up as a text field
and should be set up as a numeric field. That just might be the cause of
your problem.
 
Gee said:
I've got a query where it is supposed to return all
records where the Deadline is greater than 0. (Under
deadline is a negative number, over is positive) What I'm
getting is everything BUT 0, as in I'll get records that
have 1, 2, -9, -22...see, I don't know why I'm getting
negatives if I'm asking for >0.
The criteria looks like this:
[Overdue/Under-Deadline Days]>"0"
Click to expand...

You are testing for any strings that follow, alphabetically sorted,
after 0. Unfortunately that is all numbers, and the hyphen.

Use

[Overdue/Under-Deadline Days]>0
 
YEP! That was exactly it! Thank you!
-----Original Message-----
Gee,

From the looks of your criteria I'd say the field is set up as a text field
and should be set up as a numeric field. That just might be the cause of
your problem.

I've got a query where it is supposed to return all
records where the Deadline is greater than 0. (Under
deadline is a negative number, over is positive) What I'm
getting is everything BUT 0, as in I'll get records that
have 1, 2, -9, -22...see, I don't know why I'm getting
negatives if I'm asking for >0.
The criteria looks like this:
[Overdue/Under-Deadline Days]>"0"
What am I doing wrong?
Thanks in advance for your help.
Click to expand...


.
Click to expand...
 
The clue is in

[Overdue/Under-Deadline Days]>"0"

The quotes infer that your are dealing with a text value
and not a number and the comparison is not numeric.
 
Back
Top