Counting Records in SubReports

The UK's most regular instructor-led training courses.
Training information: access courses · Access training · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Medium Priority · Version 2003

2 posts

ReplyTue 29 Dec 2009, 14:17Delegate Ajay said...

Ajay has attended:
Access Advanced course
Excel VBA Intro Intermediate course

Counting Records in SubReports

Hi

I would like to know if there is a way to sum the record counter for all subreports into a main report,

I have used count(*) in 18 sub reports linked to my main report and would like to be able to add these all together to get a total in the header of my main report,

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	6		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£110	£115
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

210 posts

ReplyTue 5 Jan 2010, 14:39Trainer Jacob said...

RE: Counting Records in SubReports

Hi Ajay

Thanks for your post. From what you have outlined any solution we can provide does exceed the scope of this forum.

In these cases we can ask you to send us sample files and lists of waht you are trying to do, we can review and let you know the scope of work involved and any associated costs. We will not commence any work until you give instruction.

If you would like to look into this further then please reply direct to me.

Kind regards

Jacob

Mon 11 Jan 2010: Automatically marked as resolved.

· Why Do I Need To Use Access?
· User-Proofing Your Access Database: Part 1
· So You Still Haven't Learned How To Use Access Yet?
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Bring Access Up To Speed

Please browse our web site to find out more about
access courses and other Microsoft training courses.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips