Access Reports

[Bantam]

I have a field in an access report that does a calculation. Based on the calculation, I'd like the program to decide whether or not to exclude the record from listing the report. The calculation cannot be done in a query.

How would I exclude certain records from appearing on an access report based on a text field?




Thanks

 

[EagleKeeper]

Put a filter in the query itself to ignore records for which that field has a character pattern that you do not want.

 

[Bantam]

I cannot do the calculation in the query, and I need the record (which is actually a compilation of records) excluded from the report based on a calculation.

Isn't there a function in access reports to just skip to the next record, or refrain from displaying anything in the current iteration?