extended price subform

[Scottyg1987]

I am stuck for a calculation expression for 'extended price' which can be seen in the attached screenshot.

I want to times item price by quantity and deduct the discount.

Thanks.

 

[llkhoutx]

me!ExtendedPrice = me!UnitPrice * me!Quantity - nz(me!Discount)

Extrendedprice appears to be bound, it needn't/shouldn't be. Bindng it violates one of the normalization rules.

The NZ function is used on Discount because Discount may be Null.

 

[Scottyg1987]

yep put expression in, as shown in screenshot attachment but error name? is displayed when working this.

 

[llkhoutx]

What I proposed would work in VBA, for controlsource use

= me!UnitPrice * me!Quantity - nz(me!Discount)

 

[Scottyg1987]

done, thanks