Okay, I take it that you are not interested in using normalized tables
(or
perhaps you already have them and your reference to 'ct' in your original
post stood for crosstab.)
In any case, you can use the Sorting And Grouping box in report design
view
to create a group header and group footer on the Depot field, and sum the
values in the group footer. The Control Source of the sum of Retreads
text
box would be:
=Sum([Retreads])
Once again, this assumes that the Retreads field contains some kind of
numeric or currency data.
I'm not sure I have understood your question.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Reply to group, rather than allenbrowne at mvps dot org.
"Jay" <
[email protected]> replied in message
I manage a tyre bay a transporting firm. We have three depots like I
mentioned. I'm using the database to keep track of all my orders
issued(so I have an Orders + Order Details tables). I have separate
tables for Categories, Depots, and Suppliers.
The thing is, I want to be able to make a report(Tabular form layout)
with the clolumns:
Date : Order No : New tyres : Retreads : Breakdowns : Wages :
Sundries : Depot
At the bottom of each page I'd like to have the total for each column
(category) for that page. I would then like to go further, and do the
same, but for each depot. In other words there would be three
boxes at the bottom of the page totaling New Tyres, but the one
would only calculate Orders relating to the PRL depot, the other box
only the PE depot, etc. I would like to do this for all the
categories.
Hi agian. Sorry, reading thru it all again i can see I was a bit vague.
OK, so I've got tables: Orders, OrderDetails, Categories and Depots. I
then used a cross tab query, like u said, on which i based my form +
report. I have already tried what u suggested,(=sum([Retreads]) and it
works fine in the group footer. As soon as I try the same in the page
footer i either get an #error value, or a zero. I've also checked the
running sum properties, and tried all the possibilities there, with no
luck