Expression in a query

P

PJ

My output is incorrect. I have two fields one named [Capital Markets
Referral] and [Capital Markets Referral Secondary]. So if [Capital Markets
Referral] has a name in it AND [Capital Markets Referral Secondary] has a
name in it I want the output to be 80% for [Capital Markets Referral] and 20%
[Capital Markets Referral Secondary]but if just [Capital Markets Referral] =
" Public Markets" AND [Capital Markets Referral Secondary] is null then the
output should be 100% [Capital Markets Referral] .

Below is my expression but I did not do it correctly:

IIf([Capital Markets Referral]="Public Markets" And [Capital Markets
Referral Secondary] Is Null,1) And IIf([Capital Markets Referral]="Public
Markets" And [Capital Markets Referral Secondary] ,0.8,0.2)


Thanks in advance
 
K

KARL DEWEY

You are missing something.
You are testing text fields [Capital Markets Referral] and [Capital Markets
Referral Secondary] for a text value.
What field is to display 100% if the above test TRUE? What fields are to
display 80% and 20% if the above test FALSE?
 
P

PJ

If [Capital Markets Referral]=Public Markets then it would be 100%.
Otherwise, if [Capital Markets Referral] & [Capital Markets Referral
Secondary] have a value (is not null) then it would be 80% [Capital Markets
Referral] and 20% [Capital Markets Referral Secondary]

KARL DEWEY said:
You are missing something.
You are testing text fields [Capital Markets Referral] and [Capital Markets
Referral Secondary] for a text value.
What field is to display 100% if the above test TRUE? What fields are to
display 80% and 20% if the above test FALSE?

--
KARL DEWEY
Build a little - Test a little


PJ said:
My output is incorrect. I have two fields one named [Capital Markets
Referral] and [Capital Markets Referral Secondary]. So if [Capital Markets
Referral] has a name in it AND [Capital Markets Referral Secondary] has a
name in it I want the output to be 80% for [Capital Markets Referral] and 20%
[Capital Markets Referral Secondary]but if just [Capital Markets Referral] =
" Public Markets" AND [Capital Markets Referral Secondary] is null then the
output should be 100% [Capital Markets Referral] .

Below is my expression but I did not do it correctly:

IIf([Capital Markets Referral]="Public Markets" And [Capital Markets
Referral Secondary] Is Null,1) And IIf([Capital Markets Referral]="Public
Markets" And [Capital Markets Referral Secondary] ,0.8,0.2)


Thanks in advance
Click to expand...
Click to expand...
 
K

KARL DEWEY

If [Capital Markets Referral]=Public Markets then it would be 100%.
What is it? What becomes/displays 100%?
What two items/fields/objects would be 80% and 20%?
--
KARL DEWEY
Build a little - Test a little


PJ said:
If [Capital Markets Referral]=Public Markets then it would be 100%.
Otherwise, if [Capital Markets Referral] & [Capital Markets Referral
Secondary] have a value (is not null) then it would be 80% [Capital Markets
Referral] and 20% [Capital Markets Referral Secondary]

KARL DEWEY said:
You are missing something.
You are testing text fields [Capital Markets Referral] and [Capital Markets
Referral Secondary] for a text value.
What field is to display 100% if the above test TRUE? What fields are to
display 80% and 20% if the above test FALSE?

--
KARL DEWEY
Build a little - Test a little


PJ said:
My output is incorrect. I have two fields one named [Capital Markets
Referral] and [Capital Markets Referral Secondary]. So if [Capital Markets
Referral] has a name in it AND [Capital Markets Referral Secondary] has a
name in it I want the output to be 80% for [Capital Markets Referral] and 20%
[Capital Markets Referral Secondary]but if just [Capital Markets Referral] =
" Public Markets" AND [Capital Markets Referral Secondary] is null then the
output should be 100% [Capital Markets Referral] .

Below is my expression but I did not do it correctly:

IIf([Capital Markets Referral]="Public Markets" And [Capital Markets
Referral Secondary] Is Null,1) And IIf([Capital Markets Referral]="Public
Markets" And [Capital Markets Referral Secondary] ,0.8,0.2)


Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
P

PJ

This is my expression but I do not have it quite right:

USB and Piper Division of Fees: IIf([Capital Markets Referral]="Public
Markets" And [Capital Markets Referral Secondary] Is Null,1) And IIf([Capital
Markets Referral]="Public Markets" And [Capital Markets Referral Secondary]
Is Not Null,0.8,0.2)



KARL DEWEY said:
If [Capital Markets Referral]=Public Markets then it would be 100%.
Click to expand...
Click to expand...
What is it? What becomes/displays 100%?
What two items/fields/objects would be 80% and 20%?
--
KARL DEWEY
Build a little - Test a little


PJ said:
If [Capital Markets Referral]=Public Markets then it would be 100%.
Otherwise, if [Capital Markets Referral] & [Capital Markets Referral
Secondary] have a value (is not null) then it would be 80% [Capital Markets
Referral] and 20% [Capital Markets Referral Secondary]

KARL DEWEY said:
You are missing something.
You are testing text fields [Capital Markets Referral] and [Capital Markets
Referral Secondary] for a text value.
What field is to display 100% if the above test TRUE? What fields are to
display 80% and 20% if the above test FALSE?

--
KARL DEWEY
Build a little - Test a little


:

My output is incorrect. I have two fields one named [Capital Markets
Referral] and [Capital Markets Referral Secondary]. So if [Capital Markets
Referral] has a name in it AND [Capital Markets Referral Secondary] has a
name in it I want the output to be 80% for [Capital Markets Referral] and 20%
[Capital Markets Referral Secondary]but if just [Capital Markets Referral] =
" Public Markets" AND [Capital Markets Referral Secondary] is null then the
output should be 100% [Capital Markets Referral] .

Below is my expression but I did not do it correctly:

IIf([Capital Markets Referral]="Public Markets" And [Capital Markets
Referral Secondary] Is Null,1) And IIf([Capital Markets Referral]="Public
Markets" And [Capital Markets Referral Secondary] ,0.8,0.2)


Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

Try this --
USB and Piper Division of Fees: IIf([Capital Markets Referral]="Public
Markets" And [Capital Markets Referral Secondary] Is Null,1, IIf([Capital
Markets Referral] ="Public Markets" And [Capital Markets Referral Secondary]
Is Not Null,0.8,0.2))

But your wording -- I want the output to be 80% for [Capital Markets
Referral] and 20% [Capital Markets Referral Secondary] -- lead me to believe
you want the second instance to display both the 80% and 20%.

--
KARL DEWEY
Build a little - Test a little


PJ said:
This is my expression but I do not have it quite right:

USB and Piper Division of Fees: IIf([Capital Markets Referral]="Public
Markets" And [Capital Markets Referral Secondary] Is Null,1) And IIf([Capital
Markets Referral]="Public Markets" And [Capital Markets Referral Secondary]
Is Not Null,0.8,0.2)



KARL DEWEY said:
If [Capital Markets Referral]=Public Markets then it would be 100%.
Click to expand...
What is it? What becomes/displays 100%?
What two items/fields/objects would be 80% and 20%?
--
KARL DEWEY
Build a little - Test a little


PJ said:
If [Capital Markets Referral]=Public Markets then it would be 100%.
Otherwise, if [Capital Markets Referral] & [Capital Markets Referral
Secondary] have a value (is not null) then it would be 80% [Capital Markets
Referral] and 20% [Capital Markets Referral Secondary]

:

You are missing something.
You are testing text fields [Capital Markets Referral] and [Capital Markets
Referral Secondary] for a text value.
What field is to display 100% if the above test TRUE? What fields are to
display 80% and 20% if the above test FALSE?

--
KARL DEWEY
Build a little - Test a little


:

My output is incorrect. I have two fields one named [Capital Markets
Referral] and [Capital Markets Referral Secondary]. So if [Capital Markets
Referral] has a name in it AND [Capital Markets Referral Secondary] has a
name in it I want the output to be 80% for [Capital Markets Referral] and 20%
[Capital Markets Referral Secondary]but if just [Capital Markets Referral] =
" Public Markets" AND [Capital Markets Referral Secondary] is null then the
output should be 100% [Capital Markets Referral] .

Below is my expression but I did not do it correctly:

IIf([Capital Markets Referral]="Public Markets" And [Capital Markets
Referral Secondary] Is Null,1) And IIf([Capital Markets Referral]="Public
Markets" And [Capital Markets Referral Secondary] ,0.8,0.2)


Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Coding in Text box on a report 3
Error in query 1
Information from a query 1
Database engine cannot find the input table or query 4
Creating a Unique List 5
Update Query Help 2
using a calculation in a query 8
Coding in a Report 1

Top