Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 24th, 2007, 03:28 AM
Authorized User
 
Join Date: Mar 2006
Posts: 83
Thanks: 1
Thanked 0 Times in 0 Posts
Default Problem with Count() function 4 group of records

Hiya folks!

Heres a challenging one... at least for me it is:

I have a list in a report showing the sales for a specific period... such as the below:

DETAILS SECTION OF REPORT (HIDDEN):

PRODUCT QUANTITY
Hamburger (1 July) 10
Coca Cola (1 July) 20
Ginger Ale (1 July) 15
Hamburger (2 July) 5
Coca Cola (2 July) 6
Ginger Ale (2 July) 11

PRODUCT HEADER SECTON OF THE REPORT (VISIBLE - this shows sales by grouping the products for all dates):

PRODUCT QUANTITY
Hamburger 15
Coca Cola 26
Ginger Ale 26

The problem I am having is the following:

In the PRODUCT FOOTER section of the report, I have created the following function:

=Count([Product])

This gives me the count of products that appear in the DETAIL section of the report... in this case the result is "6".

But what I want it to do is to give me the result of the count of the products in the PRODUCT HEADER section of the report... therefore I should get a result of "3". But I cant seem to get this to work.

Any advice?

Thank you!!!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Iterate count within for-each-group stolte XSLT 1 November 19th, 2007 07:40 PM
is there any in built function to count page count g.tamilselvan MySQL 1 February 15th, 2006 07:43 AM
Count, sum, count a value, return records CongoGrey Access 1 April 18th, 2005 02:25 PM
Group By query with count problem ptaylor SQL Language 2 May 12th, 2004 09:27 AM
Help! - How do i count and group this gfowajuh SQL Server 2000 4 August 19th, 2003 05:13 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.