Subtotals every X number of records

  • Thread starter Thread starter clh
  • Start date Start date
C

clh

I know how to do subtotals based on the standard groupings based on the
values in a field.

Is there a way to do subtotals every certain number of records in an Access
report (Access 2003 here)? In my current specific case I need subtotals
every 15 records (don't care at all about values in the fields, just every 15
records).
 
You need to create a GroupNum column in the record source query that can be
used to group by in the report. For instance grouping the Orders records in
the NorthWind would use SQL like:

SELECT (DCount("OrderID","Orders","OrderID<" & [OrderID])+15)\15 AS
GroupNum, Orders.*
FROM Orders
ORDER BY Orders.OrderID;
 
Hello Clh,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that you would like to add subtotal
every 15 records in Access Reprot. Is it correct?
If I have misunderstood, please let me know.

In order to address your concern, I would like to explain the following.
1 Access database supports to add totals, subtotals, counts, and other
Group information. There is an aricle to share with
you.http://office.microsoft.com/en-us/access/HA101656301033.aspx

2 Regarding to your requirement, it is suggested to design the report
manually to add a record after every 15 records to display the summary data
of the above 15 data record.

Hope the above helpful. Thanks.

If there is anything unclear, let me know.

Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx

============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
 
Hi Clh,
This is Mark Han from the Microsoft MSDN Managed Newsgroup Support Team.
How are you?

I noticed that you had a post entitled "Subtotals every X number of
records". I recently replied to you in the community, however I have not
seen your response yet.

To help us better monitor this issue and assist you in an effective manner,
could you please let me know the current status of the issue?

I look forward to hearing from you.

Best regards,
Mark Han
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
 
Mark,
The link you provided was to Office/Access 2007. The OP stated "Access 2003
here". I didn't think it was possible to "manually to add a record after
every 15 records" in any version of Access reports. If you have done this (or
know how it can be done), please share the specifics.
 
Back
Top