Access 2000 How To's: Controlling Report Data

December 12, 2002

Overview

It is often the case where a developer will need to create an Access 2000 reports application capable of data selection -- for example, all transactions for a member. The data is input as parameters within a form and then passed to the report as query criteria. This is the simplest method to control report output resulting from user-selected data criteria.

Table Transactions

Fields and Types

MemberId

Number

PostedDate

PostedDater

Amount

Double

Code

Number

Create a query called qryTransactions Include memberid, posteddate, amount, and code in the query field list