Calculation Help

[Simon Glencross]

I have a form which has a stock total field which is populated by a =OnHand
function

I also have a field called RRPrice which has the cost of the item.

What I wouldlike to do now is stocktotal x RRPrice = Stock Value

I have tried the following in the control source of a text box
=OnHand([ItemCode])*[RRPPRICE] but all I get is #Name?

Any suggestions?

Thanks in advance!

 

[J. Goddard]

Did you try putting the source as =[stocktotal] * [rrprice] ?

I notice you have put [rrpprice] in the line that causes #name -
spelling mistake?

John

 

[tina]

I have tried the following in the control source of a text box

=OnHand([ItemCode])*[RRPPRICE] but all I get is #Name?

when you enter an expression in a control's ControlSource, you can't name
the textbox the same as any control or field that the expression refers to.
so make sure that your textbox is *not* named ItemCode, or RRPPRICE. also,
check the spelling of the OnHand function name, and of the two fields
referred to in the expression.

hth

I have a form which has a stock total field which is populated by a =OnHand
function

I also have a field called RRPrice which has the cost of the item.

What I wouldlike to do now is stocktotal x RRPrice = Stock Value

I have tried the following in the control source of a text box
=OnHand([ItemCode])*[RRPPRICE] but all I get is #Name?

Any suggestions?

Thanks in advance!