Filter out a set of records in a report.

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.

On Fri, 8 Sep 2006 11:54:02 -0700, Dmm
wrote:

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.



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]