Criteria not working on expression field in query

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

How did you express the criteria?

I used 0 and it works.

--
KARL DEWEY
Build a little - Test a little


"Erin Freeman" wrote:

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" wrote:

How did you express the criteria?

I used 0 and it works.

--
KARL DEWEY
Build a little - Test a little


"Erin Freeman" wrote:

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 created a test db and it worked fine...hhmmm i am not sure why it wont work
on my regular one

"KARL DEWEY" wrote:

How did you express the criteria?

I used 0 and it works.

--
KARL DEWEY
Build a little - Test a little


"Erin Freeman" wrote:

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