Another data-mismatch-in-criteria question

L

LesleyW

I have a query called qryReturns that has, amongst other things, 4 columns
from a table that are all Currency data type and an expression that adds
these 4 and is called BalDue. This query runs fine.
Then I created a query based on this one, that has 2 columns - the
autonumber key and the BalDue. It runs fine, giving me the same number of
records as qryReturns. But if I enter >1 in the criteria, to avoid all the
zero and few cents values, it gives me a data type mismatch error.
I have tried going to Properties in all the columns involved and making them
Currency but it doesn't help. I put in >1.00 but when I tabbed out it changed
back to >1. What's wrong?
 
J

Jeff Boyce

Lesley

Perhaps your second query doesn't realize that what you know is "currency"
is actually currency. Consider formatting that field in the second query.

Good luck

Jeff Boyce
<Access MVP>
 
L

LesleyW

I have already done that - all the columns involved are set to Currency (in
both queries). I have used this criteria on non-calculated currency fields
from the first query and they work fine. Should I maybe be formatting each
field within the expression, and if so, how do I do that? This is driving me
nuts. Any other ideas?
Thanks.
 
J

Jeff Boyce

Another thought, consider forcing the query field to conform ... Use the
CCurr() function in the field, rather than Currency in the format property.

Good luck

Jeff Boyce
<Access MVP>
 
L

LesleyW

Thanks for the thought, I tried it and it didn't solve the problem. I have to
leave now but will check back later in case you have any other ideas.
Thanks for trying.
 
Top