访问表和计算 [英] Access Tables and Calculations

问题描述

我在Access中有四个字段，都是/是.我想创建一个新的字段，该字段基于以下内容进行计算:如果所有四个字段均为yes，则显示yes，否则显示no.有人知道我该怎么做吗?

I have four fields in Access that are all yes/no. I want to create a new field that performs a calculation based off: If all four fields are yes then show yes or else show no. Does anyone have an idea about how I can go about this?

致谢

推荐答案

1. 创建4个类型为是/否的字段
2. 将Field5创建为计算字段->是/否

3. 在ExpressionBuilder中放入公式

1. Create 4 fields with type Yes/No
2. Create Field5 as Calculated Field -> Yes/No

3. In the ExpressionBuilder put the formula

IIf([Field1]和[Field2]和[Field3]和[Field4]，1,0)

IIf([Field1] And [Field2] And [Field3] And [Field4],1,0)

测试它:)

这篇关于访问表和计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！