Sub-forms

K

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?
 
S

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
[email protected]
 
Top