Query Problem

[wh00t]

I am using an Iif statement in a query but it is not prodicung the required results, can anyone see anything wrong?

Iif([Forms]![Form]![Field]="A","A",Iif([Forms]![Form]![Field]="B",<>"A","P"))

the first part works fine (="A"), the second part does not, although the <>"A" works when entered seperately

 

[Mile-O]

You can't enter a value of <>"A" if the Field is "B"

The first part of the IIf is the expression - in which you can use operators, the second and third argument are the results determined by the evaluation of the expression.