If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Filter out a set of records in a report.
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] |
Thread Tools | |
Display Modes | |
|
|