Sounds Easy..May be!

[robk5787]

Hey folks,
I simply want to filter out data that equals $0.00. I seem to be having issues with this. I have several other filters going, but this one does not want to work properly. any help would be great. Thanks.

 

[seany]

Do the filter in a new query? Hopeful that will work

 

[robk5787]

Currently I have this query appended to another table. I am just curious as to what the criteria expression would look like to ensure I am entering it correctly. I believe that the application recognizes this data as numbers ratehr than text due to the math calculation it is doing with this data field.

 

[Rich]

=0 in the criteria for the field?

 

[namliam]

Would need to know more about the other filters and whats goings on...Post a sample or the SQL...

Regards

 

[robk5787]

Hey thanks for the help everyone. I soon found the answer after I posted this earlier today. It seems as though the last post before this one had what was I looking for! <>0 was right on the money. Thanks again.