totals in forms

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

Hi,
I've got a table with fields: OrderDetID, ProductID, UnitpriceID, Qty and
CategoryID. I created a form (tabular view) with "colums" Order No, New
Tyres, Retreads, Breakdowns, Wheel Align, and Sundries. These are all
categories. I created a line total field in the form's query to calc. a total
for each Order No. BUT... i wanna put a total for each category in. I used
the DSum funct for this one, but the totals are incorrect and change whenever
i click somewhere else on the form.
Help pls
 
There is a good example of how this is done in the Northwind database that
ships with Access. Look at the Order form and the Order Detail form.
 
Klatuu said:
There is a good example of how this is done in the Northwind database that
ships with Access. Look at the Order form and the Order Detail form.
Click to expand...

I've "copied" a couple of ideas from NW in the past, however i think my
expl. isn't 100% correct so I'll try again. I've got a database to keep
track of my orders. These i would like to break up into categories: New,
Retreads, Breakdowns, W/Align + Sundries. The Form i'm talking about is
tabular with columns for the categories listed above. There's also a column
for the order no. So on the form you'd see the order no with its value in the
respective column. (This part is up and running) I now wnt to put totals for
each category at hte bobtom of the page(running totals) These are the ones
not working properly.
 
The concept is the same as in the orders subform in Northwind.
You put a text box for each column in your form and sum the name of the
field that is the control source for that column.
 
Klatuu said:
The concept is the same as in the orders subform in Northwind.
You put a text box for each column in your form and sum the name of the
field that is the control source for that column.
Click to expand...

Thanx, had a look at NW and finally found my problem(cahnged my query
layout). Was looking in the wrongplace the whole time.
 
Back
Top