Another data-mismatch-in-criteria question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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>
 
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.
 
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>
 
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.
 
Back
Top