Gerhardpet
asked on
Need help with IIf query/formula in Access
I need help to create a query/formula in Access
credit:IIf( [Customers]![CreditAmount] >0) then "limit" else "Not Available"
I know how to do this in Crystal reports but not Access
credit:IIf( [Customers]![CreditAmount]
I know how to do this in Crystal reports but not Access
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes that was it. Seems to work now.
ASKER
Thanks for the help
ASKER