Filter out a set of records in a report.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Working in an Accounts Payable department. Need to filter out a set of
records connected to a variable/number (Global Acct Number). Access report.
Have tried looking into setting a macro, however my programming skills are
elementary at best.
 
Working in an Accounts Payable department. Need to filter out a set of
records connected to a variable/number (Global Acct Number). Access report.
Have tried looking into setting a macro, however my programming skills are
elementary at best.
Click to expand...

Use a Query as the recordsource of the Report.

Create a new Query in the query design window. Include whatever tables
and fields you need in the report; on the Criteria line under the
Global Acct Number field type

[Enter account number to report:]

using any phraseology you wish to prompt for the user to enter an
account number. Base your Report on this Query.

When you open the report, the user will be prompted and the report
will run for just that data.

A bit better: create a little Form, frmCrit let's call it, with a
combo box on it, cboAccounts. This should show all the valid Global
Acct Number values. Use a criterion

[Forms]![frmCrit]![cboAccounts]

and put a command button on the form to open the report.

John W. Vinson[MVP]
 
Back
Top