pass value to another field

[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.

 

[KARL DEWEY]

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

 

[SylvieB]

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.

 

[KARL DEWEY]

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

--
Build a little, test a little.

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.

 

[SylvieB]

It still does not work. thanks anyway

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

--
Build a little, test a little.

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.

 

[KARL DEWEY]

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.

It still does not work. thanks anyway

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

--
Build a little, test a little.

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.