In Microsoft Access 03. Creating 2 critera for one report

Question

In Microsoft access 03.I am creating a database and want the user to have the option of two critera. Critera 1, the output on the report is filtered by accounts that have a varinace of >=10% or <=-10%. Or, Critera 2, allow the user to be able to input a specific variance on a form, that will only output on a report accounts that have that specific variance.

Answer 1

If you are using a form to collect the variance anyway, then have two reports: the 10% report and a specific variance report.

Then the user will use the form to launch the report. If they enter a specific variance then show the specific variance report. If they use the default then show the 10% report.