Calculations in a form

[Guest]

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?

 

[Guest]

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...

 

[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

 

[Guest]

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

 

[Guest]

thanks so much - I think this is a neat way to do it. Thank you so much.