Hello,
I have a series of IIf statements that return a number based on what value is displayed. I have multiple types of "European Workload" items that can appear. How can I change the IIf statement below to return [Text42] whenever any one of the European Workload items appear? Possible using a wildcard?
Heres the formula:
=IIf([Type]="European Workload Index",[Text42],"1")
Thanks,
Charlie
8  2404 
Hi,
Are [type] and [text42] database fields, or form fields?
Steve
Steve,
Thanks for responding. I'm not sure if I'm familiar with the terminology that you used (I'm still new to Access), so I'll describe what the text boxes are. [Type] is a field that is stored in a table. This table is what feeds the report for which I'm working on the IIf statement.
[Text42] is a dlookup function that sits on the report. It is not tied to any table (that is, the figure in [Text42] is not stored anywhere). It performs a dlookup from a query that is tied to a table.
As stated in my earlier post, I need an IIf statement that will give me [Text42] when [Type] is "European Workload" and then any combination of words or letters after "Workload", otherwise return a 1. I feel like it has something to do with "*" but I've tried a lot of different things and I can't seem to get it to work.
Thanks,
Charlie
Try this - =IIf([Type] Like "European Workload *",[Text42],"1")
Or, if what I read here today is correct, you might need to try this version... - =IIf([Type] Like "European Workload %",[Text42],"1")
(Just uses % rather than *)
NeoPa 32,556
Expert Mod 16PB
I'm not sure what you read Killer, but I've found that T-SQL (for MS SQL) requires the '%' but Access usually works with '*'.
I would guess the '%' is more standards compliant.
Other, more Standards Compliant SQL engines would probably favour the '%' too.
Thanks for your help everyone.
One problem I ran into with this: when what appears is just "European Workload" with nothing after it (which does sometimes happen) it gives me a "1". Is there any way that I can alter the equation so that it gives me [Text42] when "Type" is "European Workload" or it's "European Workload 9901"?
Thanks again,
Charlie
NeoPa 32,556
Expert Mod 16PB
Thanks for your help everyone.
One problem I ran into with this: when what appears is just "European Workload" with nothing after it (which does sometimes happen) it gives me a "1". Is there any way that I can alter the equation so that it gives me [Text42] when "Type" is "European Workload" or it's "European Workload 9901"?
Thanks again,
Charlie
Yes there is. - =IIf([Type] Like "European Workload*",[Text42],"1")
This doesn't require the extra space at the end of the line and will therefore match "European Workload".
You all are great. Thanks for all your help.
=IIf([Type] Like "European Workload*",[Text42],"1")
This doesn't require the extra space at the end of the line and will therefore match "European Workload".
Yeah, that's my goof - sorry.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Bart Nessux |
last post by:
Should an if statement have a corresponding else statement? Or, is it OK
to have an if statement by itself. For completeness, it seems the two
should be together, but from experience I know that a...
|
by: Jaime Wyant |
last post by:
I know I've seen this somewhere, but can't seem to google it. Is
there a way to use an alternate statement separator, other than the
default ';'?
jw
|
by: Tom D |
last post by:
I'm rewriting a database interface that our company currently has.
Currently it's using the Pear::DB interface, but we found that that was
introducing a bit too much overhead. I'm rewriting the...
|
by: slogging_away |
last post by:
Hi - I'm running Python 2.4.2 (#67, Sep 28 2005, 12:41:11) on win32, and have a script that makes numerous checks
on text files, (configuration files), so discrepancies can be reported.
The script...
|
by: Fuzzyman |
last post by:
Hello all,
The following is a copy of a blog entry. It's asking a question about
future statements and the built in compile function. I'd appreciate any
pointers or comments about possible...
|
by: Neroku |
last post by:
Hello, i would like to know what the serious definition of statements
and expressions is:
i know an expression are evaluated to a value, i.e:
1 == 2
5+7
foo( 1,2)
and a statement is...
|
by: ojorus |
last post by:
Hi!
Some questions regarding the mysqli-extension (php5)
1) Prepared statements: If I understand things right, prepared statements
will give better performance if you make several similar...
|
by: Dmitri |
last post by:
Hello!
I have a developer that is playing around with some SQL statements
using VB.NET. He has a test table in a SQL 2000 database, and he has
about 2000 generated INSERT statements.
When the...
|
by: Gary Herron |
last post by:
Ohad Frand wrote:
There is no way you can consider 'elif', 'else', 'except', and 'from'
statements. However, as someone pointed out, the kwlist from the
keyword module is the closest thing we...
|
by: Ohad Frand |
last post by:
Hi
Thanks a lot for your reply
I think the main uses for it is to study the language and to see that I
didn't miss anything else or that something is changed from one version
to another.
The...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
