计算条件 [英] Condition in calculation

问题描述

嗨

我正在为薪水报表准备一个数据库。在此，HRA应根据另一个领域提供的数据进行计算。


例如：

如果我有一个字段HRA适用在该特定字段中输入的数据应为是。或不。根据特定字段的数据，应计算HRA。


是否可以在访问中创建此类条件。



请帮帮我

Hi
I am preparing a database for salary statements. In this the HRA should calculated depending upon the data provided in another field.

For ex:
if i had a field "HRA applicable" the data entered in that particular field should be "yes" or "no". Depending upon the data of that particular field HRA should be calculated.

Is it possible to create such condition in access.


please help me

推荐答案

嗨

我正在为薪资报表准备一个数据库。在此，HRA应根据另一个领域提供的数据进行计算。


例如：

如果我有一个字段HRA适用在该特定字段中输入的数据应为是。或不。根据特定字段的数据，应计算HRA。


是否可以在访问中创建此类条件。



请帮帮我

Hi
I am preparing a database for salary statements. In this the HRA should calculated depending upon the data provided in another field.

For ex:
if i had a field "HRA applicable" the data entered in that particular field should be "yes" or "no". Depending upon the data of that particular field HRA should be calculated.

Is it possible to create such condition in access.


please help me

嗨


好​​吧，是的!! !!



MTB

Hi

Well, yes it is !!??


MTB

展开 | 选择 | Wrap | 行号

我的数据库基于查询，那么我在哪里可以用表格或查询来编写这段代码

抱歉问这个

My database is based on query, so where can i write this code in form or query
sorry to ask this

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