IIF Expression from two fields

[zburns]

I have two yes/no fields [office] and [operator] in a query and would like to reference result in another field used for report.
Rather than show -1 or 0 need to show 'office' or 'operator'. I think this could also be done with unbound control in report but don't know how to construct.
Any help is greatly appreciated.

[ItsMe]

You can place your expression directly in an unbound control or in the OnFormat event of the Report's Module.

[alansidman]

In a new table, two fields, first one contains -1 and 0, second one contains Office and Operator. Join to your table containing Yes/No field. Use field from new table that displays Office and Operator in your query and not the Yes/No field from your original table.

[InsuranceGuy]

I have two yes/no fields [office] and [operator] in a query and would like to reference result in another field used for report.
Rather than show -1 or 0 need to show 'office' or 'operator'. I think this could also be done with unbound control in report but don't know how to construct.
Any help is greatly appreciated.

Fairly difficult to follow what you're attempting, but I think you're looking for an IIF statement on a text box on your report or in your query.

Try:

=IIF([Office],"Office","Not Office")

Be aware that -1 = True, 0 = False in Access.
Therefor, this returns "Office" when [Office]=-1 and returns "Not Office" when [Office]=0.

Jeff

[zburns]

my query has one yes/no field named [A] and another yes/no field names [B]. Would like another field with expression checking value of [A] and [B]. If [A] = -1 then display 'office'. If [B] = -1 display 'operator'. record will only show one or the other. If fields = 0 or is null then leave blank. Sooo .. every record will either be blank or office or operator.
Sorry if it is still confusing. I'm thinking I could also have an unbound control on report with the expression as well?

[InsuranceGuy]

That clarifies a lot actually. Here you go:

=IIF([A],"office",IIF([B],"operator",null))

[zburns]

Thanks, worked fine. Just what I was needing.
Sorry I wasn't more clear in what I was needing.