Solved

Count of Grouped Records

Posted on 2013-06-04
4
292 Views
Last Modified: 2013-06-05
I have a sales report that groups sales by SLS_REP and TKT_NO.
I would like to have a count of the number of Tickets from each sales rep in the SLS_REP Footer. I presently get a count of the number of items sold on each ticket in the TKT_NO Footer and a total of items sold in the SLS_REP Footer. This is good information but I would also like to get a count of the number of tickets per SLS_REP.

Thanks,
Ward
0
Comment
Question by:draw58
  • 2
  • 2
4 Comments
 
LVL 29

Expert Comment

by:IrogSinta
ID: 39220899
Add an invisible textbox in your SLS_REP detail section and call it txtCountSLS.  Insert "=1" in its ControlSource (without the quotes) and change its RunningSum property to Over Group.
Then add a textbox to your SLS_REP footer section with "=txtCountSLS" in its ControlSource.
0
 

Author Comment

by:draw58
ID: 39220962
Thanks,
That worked great! Could you please tell me how I could have a grand total in the report footer?
0
 
LVL 29

Accepted Solution

by:
IrogSinta earned 500 total points
ID: 39221157
Same procedure.  Add another invisible textbox in the same section as before but this time its RunnungSum property should be Over All.
0
 

Author Closing Comment

by:draw58
ID: 39221985
Thank You!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question