wsh
(Page 1 of 4 )
This article explains how parametric queries can be used as a source for creating a Data Access Page. It also describes how to host such a page on an intranet.
Introduction
In the first tutorial on Data Access Pages, the evolution of Data Access Pages was described and a simple method of creating the page using the Wizard and hosting it on the intranet site was explained. The second tutorial dealt mainly with creating a Data Access Page from scratch starting from the design view of a page. This tutorial expands on the two previous ones and describes how parametric queries can be used as a source for the DAP. This is a popular FAQ on MS Access forums related Data Access Pages. This tutorial describes in detail how to create a DAP based on a parametric query, and host it on the intranet website.
Parametric QueriesParametric queries, as the name suggests, are queries that return a row of data from a table based on a supplied parameter. Let's assume that you are dealing with customer information such as that shown in the picture below. For each customer there are several pieces of information such as the Company Name, Contact Name, Address, etc. By using a parametric query and supplying a previously chosen parameter such as CustomerID, one can retrieve the rest of the information about that customer.
Parametric queries need not be restricted to one parameter; they could also depend on a combination of more than one parameter that retrieves the desired row or rows (since there could be more than one row satisfying the parameters). For example, the parameters could include finding all rows in a table satisfying a beginning date and an ending date.
Next: Creating a parametric query >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
|
| · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | | |
|
