显示基于另一个字段为yes的字段的内容 [英] Display contents of a field based on another field being yes

问题描述

我有一个电话号码字段（BusinessPhone），如果用户在另一个字段（业务Y / N字段）中选择了是（是/否字段），我只想在查询结果中显示。


前提是他们可以选择使用商务电话，手机或两者兼而有之。如果他们在商业中选择是，他们的商务电话将出现在BusinessPhone字段中，但是如果他们选择不，则查询应该在该字段中不为该用户返回任何内容。


提前感谢。

I have a phone number field (BusinessPhone) that I only want to display in my query results if the user has selected yes (yes/no field) in another field (Business Y/N field).

The premise is that they can choose to use their business phone, mobile phone or both. If they choose yes in business their business phone would appear in the field BusinessPhone however if they choose no the query should return nothing in that field for that user.

Thanks in advance.

推荐答案

很抱歉原谅我这不是一个是/否文本，而是一个复选框。

Sorry forgive me it is not a yes/no text however a check box.

如果你在谈论一个文本框表格，你可以使用

= IIf（isChecked，BussinessPhone，""）

If you are talking about a textbox on a form, you can use
=IIf(isChecked,BussinessPhone,"")

这是一个查询。我正在运行查询以导出到Excel。如果选中Business，我需要在该字段的条件中仅显示该用户的内容。

It is a query. I am running a query to export to Excel. I need something in the criteria of that field to only display the contents for that user if Business is checked.

这篇关于显示基于另一个字段为yes的字段的内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！