Calculations in a form

J

joan

I am trying to create a simple order entry system. I have a form with the
original data. In the formas I add the orders and price for each, I want a
total to appear. I have calculated per line and those totals work, but I
can't get the form to calculate the grand total. What should I do?
 
M

Maurice

What kind of form are you using? Continuous form or single form. what is the
datasource for the form a table or query?

Show a sample of what you want to calculate...
 
P

Patrick A

Joan,

There may be a smoother way, but here's an easy-to-implement option:

Create a query that totals up the items on the order form into the
field [GrandTotal] (perhaps based on the order id currently shown).

Drop the field [GrandTotal] onto the form.

Use a "Show Grand Total" button or the OnChange or AfterUpdate event
of the field that shows the per line total to requery the form.

Patrick
 
J

joan

Thanks so much - it was a single form. It turns out when set the default of
0 to all fields, the calculation appeared. Thanks for your help
 
Top