pass value to another field

  • Thread starter Thread starter SylvieB
  • Start date Start date
S

SylvieB

Hi everyone,

On a form, I have the following fields:
ContractValue, contractType which is a combo box with 3 different values to
choose from (Fixed, Negociated, bid).
On a report, I need to display the following fields: title, contract type,
Contractvalue and valueForBid.
If contractType = BID, the ContractValue field does not display the value
and the value of the ContractValue goes under a column named valueForBid. So
far this is what I have accomplished. On a query, I created a field called
BIDvalue.
BIDValue:IIF([ContractValue]="BID",[ContractValue]
I don't know how to show nothing on the ContractValue column because i need
to totalize the column.
Any help would be greatly appreciated. Thanks in advance.
 
Hey Karl
Thank you for your prompt answer. Unfortunately, the code below does not
work. I get an error message: "the expression you entered contains invalid
syntax".
I made a mistake earlier when writing my code, it should have been:
BIDValue:IIF([ContractType]="BID",[ContractValue]
any other suggestions?

KARL DEWEY said:
Try this --
BIDValue:IIF([ContractValue]="BID",[ContractValue],]"" )

--
Build a little, test a little.


SylvieB said:
Hi everyone,

On a form, I have the following fields:
ContractValue, contractType which is a combo box with 3 different values to
choose from (Fixed, Negociated, bid).
On a report, I need to display the following fields: title, contract type,
Contractvalue and valueForBid.
If contractType = BID, the ContractValue field does not display the value
and the value of the ContractValue goes under a column named valueForBid. So
far this is what I have accomplished. On a query, I created a field called
BIDvalue.
BIDValue:IIF([ContractValue]="BID",[ContractValue]
I don't know how to show nothing on the ContractValue column because i need
to totalize the column.
Any help would be greatly appreciated. Thanks in advance.
Click to expand...
Click to expand...
 
I had a closing bracket following comma that should not have been.
Try --
BIDValue:IIF([ContractType]="BID",[ContractValue], "")

--
Build a little, test a little.


SylvieB said:
Hey Karl
Thank you for your prompt answer. Unfortunately, the code below does not
work. I get an error message: "the expression you entered contains invalid
syntax".
I made a mistake earlier when writing my code, it should have been:
BIDValue:IIF([ContractType]="BID",[ContractValue]
any other suggestions?

KARL DEWEY said:
Try this --
BIDValue:IIF([ContractValue]="BID",[ContractValue],]"" )

--
Build a little, test a little.


SylvieB said:
Hi everyone,

On a form, I have the following fields:
ContractValue, contractType which is a combo box with 3 different values to
choose from (Fixed, Negociated, bid).
On a report, I need to display the following fields: title, contract type,
Contractvalue and valueForBid.
If contractType = BID, the ContractValue field does not display the value
and the value of the ContractValue goes under a column named valueForBid. So
far this is what I have accomplished. On a query, I created a field called
BIDvalue.
BIDValue:IIF([ContractValue]="BID",[ContractValue]
I don't know how to show nothing on the ContractValue column because i need
to totalize the column.
Any help would be greatly appreciated. Thanks in advance.
Click to expand...
Click to expand...
Click to expand...
 
It still does not work. thanks anyway

KARL DEWEY said:
I had a closing bracket following comma that should not have been.
Try --
BIDValue:IIF([ContractType]="BID",[ContractValue], "")

--
Build a little, test a little.


SylvieB said:
Hey Karl
Thank you for your prompt answer. Unfortunately, the code below does not
work. I get an error message: "the expression you entered contains invalid
syntax".
I made a mistake earlier when writing my code, it should have been:
BIDValue:IIF([ContractType]="BID",[ContractValue]
any other suggestions?

KARL DEWEY said:
Try this --
BIDValue:IIF([ContractValue]="BID",[ContractValue],]"" )

--
Build a little, test a little.


:

Hi everyone,

On a form, I have the following fields:
ContractValue, contractType which is a combo box with 3 different values to
choose from (Fixed, Negociated, bid).
On a report, I need to display the following fields: title, contract type,
Contractvalue and valueForBid.
If contractType = BID, the ContractValue field does not display the value
and the value of the ContractValue goes under a column named valueForBid. So
far this is what I have accomplished. On a query, I created a field called
BIDvalue.
BIDValue:IIF([ContractValue]="BID",[ContractValue]
I don't know how to show nothing on the ContractValue column because i need
to totalize the column.
Any help would be greatly appreciated. Thanks in advance.
Click to expand...
Click to expand...
Click to expand...
 
Let us do some testing.
First use this --
BIDValue:[ContractType]
See if you get the types or a numerical value. A number means you have a
lookup that must be used instead of "Bid".

Second try --
BIDValue:IIF([ContractType]="BID","1", "2")

--
Build a little, test a little.


SylvieB said:
It still does not work. thanks anyway

KARL DEWEY said:
I had a closing bracket following comma that should not have been.
Try --
BIDValue:IIF([ContractType]="BID",[ContractValue], "")

--
Build a little, test a little.


SylvieB said:
Hey Karl
Thank you for your prompt answer. Unfortunately, the code below does not
work. I get an error message: "the expression you entered contains invalid
syntax".
I made a mistake earlier when writing my code, it should have been:
BIDValue:IIF([ContractType]="BID",[ContractValue]
any other suggestions?

:

Try this --
BIDValue:IIF([ContractValue]="BID",[ContractValue],]"" )

--
Build a little, test a little.


:

Hi everyone,

On a form, I have the following fields:
ContractValue, contractType which is a combo box with 3 different values to
choose from (Fixed, Negociated, bid).
On a report, I need to display the following fields: title, contract type,
Contractvalue and valueForBid.
If contractType = BID, the ContractValue field does not display the value
and the value of the ContractValue goes under a column named valueForBid. So
far this is what I have accomplished. On a query, I created a field called
BIDvalue.
BIDValue:IIF([ContractValue]="BID",[ContractValue]
I don't know how to show nothing on the ContractValue column because i need
to totalize the column.
Any help would be greatly appreciated. Thanks in advance.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top