Microsoft Access Help

[marc_howarth]

Hi there,

I am trying to write an IIF expression in a query in access so far i have got:

Expr1: IIf([Marc],"Marc",IIf([Andy],"Andy",IIf([Marc] & [Andy],"Both","")))

I know this is not correct as this never shows the word "Both". The Fields [Marc] and [Andy] are both yes/no feild. I'm guessing i've messed up here:

IIf([Marc] & [Andy],

Would be grateful if someone could point me in the right direction

thanks in advance

Marc

 

[marc_howarth]

Thanks for your reply but if i type in that code it says:

The expression you enetered contains invalid syntax.

You may have entered a comma without a preceding value or identifier

I'm not too sure what this is saying, any more help would be very appreciative

thanks again

Marc

 

[marc_howarth]

thank you ever so much, works perfectly now, both those comments really helped