Chester Tugwell is a freelance Microsoft Office trainer and owner of Blue Pecan Computer Training based in Sussex, UK. He provides a comprehensive set of Access training courses as well as other Microsoft Office training options.
Including Parameter Values in a Report
This exercise is for Access users who have some experience with parameter queries and creating their own reports. A parameter prompts the end user to enter criteria each time the query is run. This exercise shows you how to display the parameter value that is given by the end user in the heading of a report based on the query.
There are three main steps we need to complete to demonstrate this:
1) Create a table
2) Create a parameter query based on the table
3) Create a report based on the query
1. Create a new table and save it as tblEmployees. The table will need to hold the following fields which you should create in design view:
Field Name Data Type
EmployeeID AutoNumber
FirstName Text
LastName Text
Location Text
Set Employee ID as the primary key
Enter the following records into this table
EmployeeID FirstName LastName Location
1 Andy Bean London
2 Claire Doubt London
3 Enid Fairview Brighton
4 Geoff Hall Brighton
5 Ivan Jones London
Close the table
2. Create a query based on this table, adding all the fields to the query grid. Then add the following parameter for the Location field.
[Which location?]
Then in the next available column in the query grid type the following into the Field row
ParaLoc:[Which location?]
ParaLoc is just the name we have given our new column – it’s not a special function or anything like that. If you are experienced user of parameter queries you may wonder we have created this column. Well essentially it is so we can store the parameter value in a field and then refer to that field in the report.
Save the query as qryLocation and close it.
3. Create a report based on this query using the Report Wizard. Use all the fields except maybe the EmployeeID field. Once the report has been created switch to design view and in the report header delete the current report heading including its box.
Open the form toolbox and draw a text box where the report heading used to be. Delete the label for the text box and then type the following into the text box:
=“Employees Report for&“ ”&[What Location?]
Print preview the report: the parameter value that you entered for the location should appear in the heading of the report. For example if you entered London as your location, the heading would read - Employees Report for London
- Related Videos
- Related Articles
- Ask / Related Q&A
- Latest threat for Microsoft: VMware Inc.
- Be Ready For the Release of Microsoft 7
- VISIBILITY.net Transforms Reporting & Analytics
- Dynamics GP Crystal Reports Design Notes
- Corporate ERP for Mid-Size Organization: Microsoft Dynamics GP Notes
- Microsoft Access in Today's Business
- The One and Only Document Reporting Engine You Will Ever Need
- Microsoft Dynamics Gp 10.0 – Improved and Enhanced
DSi Download Center - Get Nintendo DS And DSi Games For Free and Legally!
By: Sarah Brown | 24/12/2009Many people are sick of buying expensive Nintendo DS and DSi games cartridge and they want to paly games while saving their money, so I will show you where you can download Nintendo DS and Dsi games for free and legally. Not many people are aware that copyrighted Nintendo DS and DSi games can be downloaded on the internet legally. DSi Download Center is a membership based program that has more than 250,000 Downloads making it the Biggest Database for the DSI!
Know the information USB sticks
By: John Milton | 24/12/2009Now in the market there is high demand of usb sticks among its users. Seeing this the producers of usb sticks now focussing more on its reliability.
Download Jak and Daxter The Lost Frontier PSP Game
By: Sarah Brown | 23/12/2009PSP UMD discs are becoming quite expensive these days, many gamers are seeking for new alternatives to get the newest and their favorite PSP games for cheap. This article will expose on how and where you can download Jak and Daxter The Lost Frontier for less than $0.01. Jak and Daxter The Lost Frontier is already released on PSP handheld, so you can proceed to download the game instantly.
A Photography Course For All The Family
By: Dan Feildman | 23/12/2009Excellent Digital Photography Courses Introducing Free Digital Photography Guide called "How To Take Beautiful Digital Pics Made Simple". The latest tips on how to use a digital camera like a pro.
Reinforce Database Management with Remote DBA
By: Kashif Mukhtar | 23/12/2009Databases are the foundation of the digital economy. They store the information that run businesses and organize the vast amount of data that is created on a regular basis. Even though e-business infrastructures are requiring stronger database support to sustain their 24x7 operations, shrinking IT budgets are forcing companies to reduce the size of their DBA staff. With databases growing in size and complexity, the role of the already overburdened DBA is becoming increasingly difficult.
Download Full Version Movies - Downloading Movies Have Never Been Easier - Download as much and as often as you like for one fee!
By: Dimitar Mishev | 22/12/2009We as movie watchers have come a long way since the introduction of movie tapes and watching movies from our home. From beta max to the VCR tapes, we have rented and recorded thousands of movies and still do.
Download Dvd Movies Safely - If You Are Looking To Download Dvd Movies, Check Out These Tips - Amount of Content Available
By: Dimitar Mishev | 22/12/2009There are so many of us now days that are trying to find ways to save some money, and one of these ways is cutting back on movie purchases. If you are one of these then you will be happy to know that there are places that you can download DVD movies right on the Internet. And, not only can you download some great movies, you can also burn them to a disc and play them in a DVD player and your computer.
Download Movies Full Length In Your Own Home - Why Are You Wasting Time At The Video Store - Have you seen the price of DVD's lately?
By: Dimitar Mishev | 22/12/2009You are no longer stuck with the local video store on the corner, which by the way is always out of the new releases, to get your movie rentals. You can now download movies full length right onto your computer and even burn them to disc.
Excel SUMIFS Function
By: Chester Tugwell | 03/07/2009 | SoftwareSUMIFS is a function that first appears in Excel 2007. You may have previously used SUMIF to sum up values in a list based on criteria in another column. SUMIFS works the same way but allows you to use multiple criteria either in different columns or the same column.
Create A Drop Down List In Excel
By: Chester Tugwell | 03/07/2009 | SoftwareDrop down lists are a great addition to a worksheet making data more efficient and also restricting what values can be entered into a cell.
Excel Mortgage Payment Formula
By: Chester Tugwell | 22/06/2009 | SoftwareA walk through of the PMT function in Excel which allows you to calculate monthly repayments on a mortgage.
Tips and Tricks for working with Microsoft Access Reports
By: Chester Tugwell | 18/06/2009 | DatabasesA selection of tips and tricks for working in Microsoft Access reports. Not all tips will be relevant to all versions of Access
Tips and Tricks for working with Microsoft Access Forms
By: Chester Tugwell | 18/06/2009 | DatabasesA selection of tips for working with Microsoft Access Forms. Not all tips will be relevant to all versions of Access.
Tips and Tricks for working with Microsoft Access Queries
By: Chester Tugwell | 18/06/2009 | DatabasesA collection of tips and tricks that you may find useful when working with queries in Microsoft Access.
Displaying Parameter Values in a Microsoft Access Report
By: Chester Tugwell | 18/06/2009 | DatabasesIf you use parameter queries and then base reports on those queries this tutorial is for you. It will show you to display the parameter values that have been used in the heading of the report.