Nesting IIf query

[peter_lawton]

I currently have a field in a query set as



ActualPublishersShare: IIf([INCOME TYPE] Like "Perf*","0.005","0.0025")*100

This works very nicely

I need to include a "Sync*" parameter

I've tried

ActualPublishersShare: (IIf([INCOME TYPE] Like "Perf*","0.005","0.0025")*100), (IIf([INCOME TYPE] Like "Sync*","0.005","0.0025")*100)

and

ActualPublishersShare: IIf(Eval([INCOME TYPE] Like ("Perf*", “Sync*)),"0.005","0.0025")*100

plus other small variations. Access usually tells me I'm using too many parentheses but I'm sure it's not that (I've tried jsut about every possible combination). I pretty sure I'm making an elementary mistake in understanding the syntax.

If someone could elucidate I'd be very grateful

Peter

[pbaldy]

If I understand the goal correctly, try

IIf([INCOME TYPE] Like "Perf*" OR [INCOME TYPE] Like "Sync*","0.005","0.0025")*100

Given that you're performing math, I don't think you want the numeric values in quotes.

[peter_lawton]

Thank you very much Sir. That worked perfectly (even with the quotes!)

peter

[pbaldy]

No problem, glad it worked for you.