Sub-forms

[KF101]

How do I create a sub-form to perform calculations?

My database is for a retail outlet and I need a sub-form to multiply
quantity and cost together.

Help anybody?

 

[Steve]

Base your sobform on a query and do the math in the query. Put the following
expression in the first blank fileld:

ExtendedCost:[Quantity]*[Cost]

Set the control source of a field on your subform to ExtebdedCost.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)