Criteria not working on expression field in query

E

Erin Freeman

Hi there,

I am hoping someone can help me.
I have an expression in a query
I-Amount Balance: Round([Invoice Total]-[I-Amount Paid],2)

I would like to show all the records that do not equal 0 as some invoices
have been overpaid and some underpaid and some not paid at all. THese are all
Currency fields

I have tried multiple times to get the criteria to work but i cant seem to.
Any ideas. Can i just not use criteria on field that is an expression?

Thanks in advance
erin
 
E

Erin Freeman

I tried that, i wonder if it has something to do with the way the fields are
set up. I have them all as currency type in the tables and they are set to 2
decimal places.....

KARL DEWEY said:
How did you express the criteria?

I used <>0 and it works.

--
KARL DEWEY
Build a little - Test a little


Erin Freeman said:
Hi there,

I am hoping someone can help me.
I have an expression in a query
I-Amount Balance: Round([Invoice Total]-[I-Amount Paid],2)

I would like to show all the records that do not equal 0 as some invoices
have been overpaid and some underpaid and some not paid at all. THese are all
Currency fields

I have tried multiple times to get the criteria to work but i cant seem to.
Any ideas. Can i just not use criteria on field that is an expression?

Thanks in advance
erin
Click to expand...
Click to expand...
 
E

Erin Freeman

i created a test db and it worked fine...hhmmm i am not sure why it wont work
How did you express the criteria?

I used <>0 and it works.

--
KARL DEWEY
Build a little - Test a little


Erin Freeman said:
Hi there,

I am hoping someone can help me.
I have an expression in a query
I-Amount Balance: Round([Invoice Total]-[I-Amount Paid],2)

I would like to show all the records that do not equal 0 as some invoices
have been overpaid and some underpaid and some not paid at all. THese are all
Currency fields

I have tried multiple times to get the criteria to work but i cant seem to.
Any ideas. Can i just not use criteria on field that is an expression?

Thanks in advance
erin
Click to expand...
Click to expand...
 

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

Cumulative formula for word table 0
Creating a Chart on form from selected data in query. 0
Expression Builder query with zero amounts 5
Criteria for select query. 2
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Not equal to zero 3
Running balance for debit and Credit using query in Access 2007 0
Remaining Balance Query 2

Top