Solved

Need help with IIf query/formula in Access

Posted on 2016-09-22
6
44 Views
Last Modified: 2016-09-22
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
0
Comment
Question by:Gerhardpet
  • 3
6 Comments
 
LVL 50

Assisted Solution

by:Ryan Chong
Ryan Chong earned 250 total points
ID: 41810490
quick try:

credit:IIf( [Customers]![CreditAmount] >0,  "limit" , "Not Available")
0
 
LVL 1

Author Comment

by:Gerhardpet
ID: 41810503
Almost. It does show "Note Available" but instead of showing "limit" it shows #Error
0
 
LVL 13

Accepted Solution

by:
John Tsioumpris earned 250 total points
ID: 41810507
Maybe you have nulls
IIf(Nz( [Customers]![CreditAmount],0) >0,  "limit" , "Not Available")

Open in new window

0
 
LVL 1

Author Comment

by:Gerhardpet
ID: 41810509
Yes that was it. Seems to work now.
0
 
LVL 1

Author Closing Comment

by:Gerhardpet
ID: 41810577
Thanks for the help
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question