G
Guest
I cannot run a query with this iff statement.
All it is meant to do is look at the business and cost centre, return the
integer of someone's age or return their age within the upper and lower
limits of redundancy age.
IIf([oribus]="MainBusiness" And ([oldcostcen]<>"North" Or
[pldcostcen]<>"West"),Int([pnageactual]),Min(Max([Z Redundancy]!Age) Or
Max([pnageactual] Or Min([Z Redundancy]!Age))))
Does anyone have any suggestions as to why this query does not work.
Thanks
Nuno
All it is meant to do is look at the business and cost centre, return the
integer of someone's age or return their age within the upper and lower
limits of redundancy age.
IIf([oribus]="MainBusiness" And ([oldcostcen]<>"North" Or
[pldcostcen]<>"West"),Int([pnageactual]),Min(Max([Z Redundancy]!Age) Or
Max([pnageactual] Or Min([Z Redundancy]!Age))))
Does anyone have any suggestions as to why this query does not work.
Thanks
Nuno