Access uses the query--1.4. Considerations for performing calculations in a query

Source: Internet
Author: User
Tags count query

4. Considerations for performing calculations in queries

If you want to display the results of a calculation in a field, you can use the predefined calculations or custom calculations that Microsoft Access provides. Using predefined calculations of the so-called "total", you can calculate the following measures for a group of records or for all records: SUM (sum), average (AVG), Quantity (count), Minimum (min), maximum (max), standard deviation (StDev), or variance (Var). You can select the total calculation to be performed on each field.

Aggregate function count cannot include records with null values (NULL) at the time of calculation. For example, the Count function returns the number of all no Null-value records. There is a way to count the null value, or you can convert the null value to zero for calculation. If you want to find the total number of records that contain Null values, use the asterisk (*) wildcard character in Count.

When you display a calculated result in a field, the results are not actually stored in the Datum form. Instead, Microsoft Access will recalculate every time the query is executed so that the results of the calculations always take the most recent data in the database. Therefore, the calculation results cannot be manually updated.



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.