Expression Builder in Access Reports

[csland]

I work for a landscape company and I am trying to create a customer specific report by linking only the services each client receives, leaving out the services they dont receive, we have over 50 different types of services we offer. I can get the expression to pull the correct information separately but I don’t know how to build the expression together. Each expression is listed below. Any help would be greatly appreciated.



=IIf([Call List- Cut Backs.2010 Season Status]="Automatic","Automatic Cut Backs",IIf([Call List- Cut Backs.2010 Season Status]="Call Every Year","Call Every Year Cut Backs"," "))

=IIf([Call List- Annuals.2010 Season Status]="Automatic","Automatic Annuals",IIf([Call List- Annuals.2010 Season Status]="Call Every Year","Call Every Year Annuals"," "))

[Robeen]

Are you still needing help on this?
If so, please reply to this and I might be able to help you solve your problem.