Total | search
Click here to view Total news from 60+ newspapers.
Bookmark or Share- Use parameters to ask for input when running a queryYou can design a query to prompt you for one piece of information, such as a part number, or for more than one piece of information, such as two dates. For each parameter, a parameter query displays a separate dialog box that prompts you for a value for that parameter.
- Sum data by using a query - Microsoft SupportSum data by using a Total row. You can add a Total row to a query by opening your query in Datasheet view, adding the row, and then selecting the aggregate function that you want to use, such as Sum, Min, Max, or Avg. The steps in this section explain how to create a basic select query and add a Total row.
- Create a simple select query - Microsoft SupportWhen you want to select specific data from one or more sources, you can use a select query. A select query helps you retrieve only the data that you want, and also helps you combine data from several data sources. You can use tables and other select queries as data sources for a select query.
- Summing in reports - Microsoft SupportIn any Access report that contains numbers, you can use totals, averages, percentages, or running sums to make the data more understandable. This article describes how to add these elements to your report.
- Count data by using a query - Microsoft SupportYou add a Total row to a query by opening your query in Datasheet view, adding the row, and then selecting the Count function or another aggregate function, such as Sum, Minimum, Maximum, or Average. The steps in this section explain how to create a basic select query and add a Total row.
More
