您^(Did)知道您可以在Microsoft Access中计算查询中的字段吗？如果用户想要查询中的计算字段，则用户需要输入计算字段的名称、冒号以及查询设计网格的字段^(Field)行中的一列中的计算。

计算字段是单独的记录计算，因为每个计算只涉及特定记录中的字段。

在 Access 中创建计算字段

打开微软访问^{(Microsoft Access)}。

创建表或现有表。

创建一个查询。

要创建查询，请转到创建^(Create)选项卡并单击查询^(Queries)组中的查询设计^{(Query Design)}。

在右侧，您将看到一个添加表^{(Add Table)}窗口；选择要计算的表。

然后单击Add Table^{(Add Table)}窗口底部的Add Selected Tables 。

表格将出现在窗口的上部。

在底部窗口中，您将看到设计网格^{(Design Grid)}。

设计网格^{(Design Grid)}是一种工具，它通过将窗口上部选定表中的字段放置到窗口下部来创建查询。^(Query)

在字段^(Field)行上，单击下拉箭头并选择要包含在Query中的每一列的字段。

在本文中，我们要计算三年内的出生率总数。年份包括 2018 年、2019 年和 2020 年。

在列的最后，我们将添加字段；“三年内的总出生人数^{(‘Total Number of Births in Three Years)}。”

我们将右键单击“三年内出生总数”^{(‘Total Number of Births in Three Years’)}字段。

在快捷菜单中，单击缩放^(Zoom)。

将打开一个缩放^(Zoom)对话框。

在缩放^(Zoom)对话框中，您将看到其中的字段文本；因为你选择了它。

根据你的计算写出公式。

例如 –Total Number of Births in Three Years: [2018] +[2019] +[2020]。

然后按OK。

然后单击左侧结果^(Results)组中的运行。^(Run)

您将看到计算结果。

我希望这有帮助; 如果您有任何问题，请在下方发表评论。

阅读^(Read)：如何在 PowerPoint 幻灯片中添加评论^{(How to add Comments in PowerPoint slides)}。

How to create Calculated Fields in Access

Did yоu know that you could calculate fields in the query in Microsoft Access? If the user wants a calculated field in a query, the user needs to input a name for the calculated field, a colon, and the calculations in one of the columns in the Field row of the query’s design grid.

A calculated field is an individual record calculation because each calculation only involves fields in a specific record.

Create Calculated Fields in Access

Open Microsoft Access.

Create a table or an existing table.

Create a Query.

To create a Query, go to the Create tab and click Query Design in the Queries group.

Over on the right, you will see an Add Table window; choose the table you want to calculate.

Then click Add Selected Tables on the bottom of the Add Table window.

The table will appear on the upper part of the window.

On the bottom window, you will see the Design Grid.

A Design Grid is a tool that creates Query by placing fields from the selected table in the window’s upper parts to the lower parts of the window.

On the Field row, click on the drop-down arrow and choose the fields for each column you want to include in the Query.

In this article, we want to calculate the total number of birth rates in three years. The years include 2018, 2019, and 2020.

At the last of the column, we will add the field; ‘Total Number of Births in Three Years.’

We will right-click the ‘Total Number of Births in Three Years’ field.

In the shortcut menu, click Zoom.

A Zoom dialog box will open.

In the Zoom dialog box, you will see the field text inside it; due to you selecting it.

Write the formula according to the calculation you are making.

For example – Total Number of Births in Three Years: [2018] +[2019] +[2020].

Then press OK.

Then click Run in the Results group on the left.

You will see the result of your calculation.

I hope this helps; if you have questions, please comment below.

Read: How to add Comments in PowerPoint slides.

Related posts

• NVIDIA Control Panel Access拒绝 - 不会应用设置

• 如何在Word Quick Access Toolbar上展示Spelling and Grammar tool

• 如何从Logon screen中删除Access button的Ease

• 在Chrome中为Remote Access主机启用更少的针对性身份验证

• 什么是远程访问木马？预防、检测和清除

• 如何Backup and Restore Quick Access Folders在Windows 10

• Fix Access Control Entry在Windows 10中腐败错误

• 如何改变Gridline Style and Background Color在Access

• NeoRouter是Zero Configuration Remote Access & VPN Solution

• 什么是Dark Web or Deep Web？如何Access & Precautions

• 如何启用或Disable NTFS最后Access Time Stamp更新

• 如何使用Microsoft Access创建Report

• Access FTP Server在Windows 10中使用Command Prompt

• ERR NETWORK ACCESS DENIED | ERR INTERNET DISCONNECTED

• PowerShell Get-Appxpackage不起作用或Access被拒绝

• MDB Viewer Plus：View and Edit Microsoft Access Database Files

• 如何在Microsoft Access Create and Modify Query

• TeamViewer：免费的远程访问和控制软件

• 如何在Access使用Application Parts

• 无法在OS上设置新的Owner，Access在Windows 10上被拒绝