Search form currency field can't use .00

[wnicole]

I have a currency field in my search form but am forced to use whole numbers (ex: $45 works but $45.00 comes up null when there are records)



ThiS is fine when u know this is what us have to do however for someone searching that doesn't may assume there are no records.

Can u tell me if i chose the wrong format? What can I do?

[rpeare]

is your 'search' coming from a field on a form? Have you got the field on that form correctly formatted (currency or fixed with 2 decimal places)? Are you actually typing in the $ when you supply the lookup value? You don't need to if you are. When you type in your value, let's say 15.41 and you have a value on your table or query that is 15.41 is it correctly pulling those records, or is it eliminating the decimal places and only finding items that have a value of 15? If it is only finding values of whole numbers it definitely sounds like formatting issue on your search criteria and not necessarily a problem with the query itself.