Solved

IIf Expresion Builder

Posted on 2006-06-29
11
370 Views
Last Modified: 2012-06-22
I get an error in my report using the following expression:

=IIf([progtype_desc]="Kick-Off Program","Kick-Off Programs",[progtype_desc])

I am trying to do it make the value 'Kick-Off Program' plural in my report.

Thanks for your time
0
Comment
Question by:tdunbar317
  • 3
  • 3
  • 2
  • +1
11 Comments
 
LVL 35

Accepted Solution

by:
Raynard7 earned 50 total points
Comment Utility
It should work if you copy and paste the value into the source query for the report;  And then reference the value;

ie progtype_desc_2: IIf([progtype_desc]="Kick-Off Program","Kick-Off Programs",[progtype_desc])
0
 
LVL 84
Comment Utility
What's the error you're getting?
0
 
LVL 84
Comment Utility
Also, since this is a report, I'm betting you must have the [progtype_desc] field on your report somewhere ... not merely in the report's REcordsource, but actually on the report (you can set it .Visible=False if you don't want to see it).
0
 
LVL 4

Expert Comment

by:Carl2002
Comment Utility
Is progtype_desc part of the report ?
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:tdunbar317
Comment Utility
Yes, the progtype_desc is a field in the report. The query is used by many reports but I have one report in particular where I need to make the result plural.
0
 

Author Comment

by:tdunbar317
Comment Utility
I see what my problem is; I need to do the IIF in the query, rather than in the report field. Since that field is used in many reports I created another field in the query with the IIF to use in the report.
0
 
LVL 84
Comment Utility
Yes, that's what Raynard7 suggested you do ...
0
 
LVL 35

Expert Comment

by:Raynard7
Comment Utility
Is my Solution Working?
0
 

Author Comment

by:tdunbar317
Comment Utility
Yes, the tip the Raynard7 provided worked for me. Thanks for the help!
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
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…
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…
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…

762 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

7 Experts available now in Live!

Get 1:1 Help Now