Solved

Need help with IIf query/formula in Access

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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 views 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 Microsoft Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

743 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

13 Experts available now in Live!

Get 1:1 Help Now