creating a "line total" price in design view

[rvd48]

i have a form with a datasheet, the important fields are "Unit Price" and "Quantity".

i want it to display the sum of: "Unit Price" Times "Quantity",

i have gone into design view, added a new field and written this: Clng(([Quantity]*[UnitPrice])AS[Line Total] with "line total" as the name of the field.

when i go into DataSheet view, all the entries in the "line total" field come up as: #Name?

could someone help me on this, on what i need to change in my statement?

cheers.

 

[Rich]

=[Quantity]*[UnitPrice] as the control source for an unbound textbox

 

[=TB=]

i have a form with a datasheet, the important fields are "Unit Price" and "Quantity".

i want it to display the sum of: "Unit Price" Times "Quantity",

i have gone into design view, added a new field and written this: Clng(([Quantity]*[UnitPrice])AS[Line Total] with "line total" as the name of the field.

when i go into DataSheet view, all the entries in the "line total" field come up as: #Name?

could someone help me on this, on what i need to change in my statement?

cheers.

Set the control Source of the text box

 =([Unit Price]*[Quantity])

Set the Name of the text box to Line Total

 

[rvd48]

thanks for that guys, such a simple piece of code, who would thought...