Solved

Need help with IIf query/formula in Access

Posted on 2016-09-22
6
38 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 49

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

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…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now