Calculated Field On A Query

[CSmith]

I can't get my query to return results when i set the criteria <="$5000.00" in the calculated field column. There are definitely records in the table that match the criteria ... Please help.

[Rabbit]

Assuming that your field is stored as Currency, the data itself is still stored as a number, it only displays as currency. Use 5000 instead of "$5000.00"

[MMcCarthy]

I can't get my query to return results when i set the criteria <="$5000.00" in the calculated field column. There are definitely records in the table that match the criteria ... Please help.

Rabbit is correct.

However, it looks like you are storing the currancy as text in which case you can't evaluate it. You have two options in this case.

1. Change the datatype to currancy
2. Use the following function

CCur([FieldName]) <= 5000

Mary