Cannot pull value of 0

[LilMissAttack]

This seems like it would be simple, but I am having problems pulling records with "0" in a certain field. These are not null but have a zero in the table. thanks!

[boblarson]

What's the datatype of the field in the table?

[LilMissAttack]

Hi, it's Number

[boblarson]

What type of number? If it is single or double, you could be suffering from floating point errors which can have it really be
0.00000001
or something like that so it doesn't really equal 0. What is the other type of data being stored? Do you need decimal places?

[rpeare]

What query criteria are you using when you try to pull information?

[LilMissAttack]

Yes it is double...I am pulling it from a linked table..it has the decimal places set to Auto. I am trying to pull it simply by 0

[rpeare]

No criteria listed yet. To what decimal place are you interested in? if you don't care about anything that is 0.anything then you could have a field that is int(numberfield) and filter out any 0 items on that field.

int just takes the integer value of a number and ignores all decimals.

[boblarson]

Yes it is double...I am pulling it from a linked table..it has the decimal places set to Auto. I am trying to pull it simply by 0

That would be your problem. If you don't need the decimal places then change it to LONG instead of Double. Then the criteria of 0 would work. If you can't change it then you would have to do what rpeare said and you will need another field in your query for the criteria. You create it like:


MyField:int([OriginalFieldNameHere])

and then you can use 0 in the criteria for that. You don't need to include that field in the displayed columns, just uncheck the display checkbox.