Select query for zero amts

[Guest]

Hello,

I have a table with codes that identify transactions with dollar amts.I
created a query to select by individual codes to find total amounts for each
code but i have a code that can represent either a dollar amount or a zero
amount.For example :

CODE
CRI 245.00
CRI 00.00
How do i select only the code CRI that represents the zero dollar amount
instead of the code CRI that contains a dollar amount?
Thanks

 

[Jeff Boyce]

Without some idea of how you are storing your data, it will be difficult to
offer specific suggestions. When you say you have a code that can represent
more than one value (zero or non-zero), how do YOU tell the difference?

 

[Guest]

Sorry about that Jeff,

There is a transaction field for every entry into the data base such as

Trans Code AMOUNT Description
2345 CRI 45.65 Monitor
4523 CRI 00.00 Monitor/Cancelled

I just wated to have the query select all transactions with a CRI zero
dollar amounts so when i run a report, the transactions with zero dollar
amounts will not appear on the report.Is it possible?

 

[Jeff Boyce]

It seems like you could add a criterion in your query, on the Amount field,
something like:

<>0