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
LVL 1
GerhardpetAsked:
Who is Participating?
 
John TsioumprisSoftware & Systems EngineerCommented:
Maybe you have nulls
IIf(Nz( [Customers]![CreditAmount],0) >0,  "limit" , "Not Available")

Open in new window

0
 
Ryan ChongCommented:
quick try:

credit:IIf( [Customers]![CreditAmount] >0,  "limit" , "Not Available")
0
 
GerhardpetAuthor Commented:
Almost. It does show "Note Available" but instead of showing "limit" it shows #Error
0
 
GerhardpetAuthor Commented:
Yes that was it. Seems to work now.
0
 
GerhardpetAuthor Commented:
Thanks for the help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.