1. Registered User
Join Date
Apr 2004
Posts
3

Could anyone tell me how to sum the total of a record?
I can do it by entering each field in the equation but it's quite long winded. Can I do one that is across the board no matter how many fields I have?

2. Registered User
Join Date
Oct 2003
Location
Ger
Posts
1,969
In the Report try to use a hidden textbox and make the Summation in every Group. Then use it the Sum of the totals

3. Registered User
Join Date
Apr 2004
Posts
3
and send fixtures out to every store we have based on this (could be up to 180-200 this year).The Attribute_Table has the 'fixture name' and 'count' as fields and each fixture item as records
I need a query to link all the stores Attribute_Tables with the 'InventoryonHand_Table' but would prefer to link just a total of each record rather than 180-200 different pieces of info.
In excel what I want would simply be =sum(a1:a99) is there a formula I can use in Access that does this or do I have to rely on =A1+A2+A3.... etc?

4. Purveyor of Discontent
Join Date
Mar 2003
Location
The Bottom of The Barrel
Posts
6,102
Actually, it's closer to your original example then you might think.

Simply put =sum(yourField) in the FOOTER section for whatever you'd like to sum. I assume you are doing this with a report.

5. Registered User
Join Date
Dec 2003
Location
Dallas, TX
Posts
1,004
Hi BigRedBus,

Without seeing your database seems like you would have a field already for each record that holds the Totals. In your report, place that Totals field on it, then in the ReportFooter place a TextBox and call it SubTotals or something. In that TextBox (SubTotals) place your calculation for the Totals fields above...something like this:
---------------------------------------------------------------
No. Item Qty
1. Shoes 5
2. Shirts 6
3. Hats 10

All that is in the ReportDetailSection.
---------------------------------------------------------------
[SubTotals] =Sum([Qty])

This line above goes in the ReportFooterSection
---------------------------------------------------------------

That will give you the Total for all listed items above that have a Qty.

have a nice one,
Bud

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•