Presumably the report is based on a query, and the calculated field is in
the query? If so, you should be able to use the Between operator in the
Criteria row of your query, or in the WhereCondition of your OpenReport
action.
If the query is giving the wrong wrong results, the reason would be that
Access has misunderstood the data type, e.g. it is applying a string
comparision when you expected a numeric comparison. For details on how to
prevent that issue, see:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html
If you want something printed in red when certain conditions are met:
1. Open the report in design view.
2. Select the field to be sometimes red.
3. Choose Conditional Formatting from the Format menu.
