Criteria not working on expression field in query

  • Thread starter Thread starter Erin Freeman
  • Start date Start date
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
 
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...
 
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...
 
Back
Top