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.