The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Counting Records in SubReports

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Counting Records in SubReports

Resolved · Medium Priority · Version 2003

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

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,

For upcoming training course dates see: Pricing & availability

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.

Access articles

· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· How To Filter And Sort Data In Access 2010 Tables
· Find Out All About Microsoft Access Report Sections
· Interested In The Golden Rules For Building Access Databases?
· Access 2007 Is All About Systems

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

Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips

Hi, can you help.

I'm creating a vast relational database and have spent ages creating forms. I have command buttons that jump to related forms and series numbers are being picked up across the different forms but when I try to add records to the rela..

» Forum post: Integrity constraint violated - parent key not found

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions