totals in forms

[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

 

[Klatuu]

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.

 

[Jay]

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.

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.

 

[Klatuu]

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.

 

[Jay]

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.

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