How to Display Data for More Than One Month on Access Reports

Create a report based on criteria you specify.

One of the most useful features of Microsoft Access is the ability to create customized queries and reports that can display just the data you want to see. This allows users to filter and sort even the largest and most complex databases without sifting through pages worth of unrelated output. Designing a report that is based on the criteria users input allows anyone who uses the Access database to display the information they want, even if that data spans several months.

Instructions

1. Log on to your computer and open Microsoft Access. Open the database you want to work with.

2. Go to the ribbon and click the "Create" tab. Click the "Query Design" icon.

3. Double click the "Create Query in Design View" option. Choose the table you want to use in the query. Click "Add" then close the "Show Table" window.

4. Choose each field you want to include in the query and double click to add it. Place your cursor in the date field you want to use and type "Between [Enter start date] and [Enter end date]" in the criteria box. Click "Save" on the Quick Access toolbar and give your query a descriptive name.

5. Go to the navigation pane and click the query you just created. Click the "Create" tab and then the "Reports" group. Choose "Report" to have Access automatically create the report based on the query.

6. Click "Save" on the "Quick Access" toolbar and type a name for your report. Double click the report to open it, then enter the dates when prompted. You can choose to have the report display any time period you wish.

References

• University of Wisconsin at Eau Claire: Access Queries
• Georgia Perimeter College: Access Reports