Criteria

  • Thread starter Thread starter Lena
  • Start date Start date
L

Lena

How do you get a query to return the results of < $0 (a negative currency
amount) on a query
 
First off, is the datatype of that field in your table set to currency? How
many decimal places is it set to? Is it rounding or not rounding?
 
It is set to currency, with 2 decimal places and it is not rounding at all.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not equal to zero 3
Simple Question on Addition 3
Use In() Expression as Query criteria with guts from Function 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Criteria not working on expression field in query 3
Query result won't display negative currency. 7
query showing - number and + total 1
Question on Iff Statement 1

Back
Top