IIf command not working

[Lifendason]

Hey all, I am new to this forum and would like some help.



I have a report that has a text box which I'm trying to get to populate with information in the query, but the table it builds from is controlled by a smaller table via a combo box.

The combo box table is laid out as below with two columns:

ServiceID SERVICES
1 Cooking

2 Cleaning

3 Dusting

...and etc



How can I get the report to reference the SERVICES column instead of the ServiceID column?


I have tried:

=IIf([ServiceID]="1",1,0)

and also

=IIf([ServiceID]="Cooking",1,0)

and no luck.


Any help would be appreciated and BTW, I am only a novice.

[JoeM]

Is your Report based on the table, or a query?

If you create a query linking the Combo Box Table to your Main Table, you can return the SERVICES field in your query, and hence, in your Report.

[pbaldy]

Well, this wouldn't have quotes:

=IIf([ServiceID]=1,1,0)

If you want to look at the text try:

=IIf([ServiceID].Column(1)="Cooking",1,0)

[Lifendason]

Thanks for the replies.

The report references a query based on multiple tables.

@ pbaldy; I tried your way and get the undefined function in expression error.

[Lifendason]

Okay I got it!

It was what pbaldy stated before: =IIf([ServiceID]=1,1,0)

I kept on putting the "" in there and it would not work, I guess "" is for text.

Thanks pbadly and everyone that replied!!

[pbaldy]

Happy to help!