SUmming Line totals

  • Thread starter Thread starter SDDIA
  • Start date Start date
S

SDDIA

OK - I have a subform that has cells that have each have
calculated values in them. How can I get the form to ADD
the totals of COLUMNS in my datasheet form if the
accurate data is only in the form and not in a table
anywhere I can fined? I am really confused and can't
figure it out. Please help - any help ios appreciated
 
The simplest approach is to create a query, and create your calculated
columns there. You can then use the query as the RecordSource for your form.

For an example, open the Northwind sample database.
Open the query named "Order Details Extended".
See how the calculated fields are entered.
This query is the source for the form "Orders Subform".
 
Back
Top