Not equal

[slimjen]

Hi all, using access 2010. This may sound like a silly question, but can anyone tell me what exactly does <> equates to when using it in a query? ex. <>0. I know it means not greater or less than, but It doesn't seem to query correctly. What can be used instead?
Thanks

[JoeM]

Can you give us an example of what you are trying to do?
What is the data-type of your field (number, text, etc)?
Can you have null values or empty strings?

[slimjen]

data-type is number. can have null values. Trying to say not = 0. Trying to correct someone elses query

[JoeM]

<>0 should work then, though if you have nulls, you may have to use the NZ function to address those.

If you need help, post the SQL code of your query here, and an example of a record or two that is not working correctly.