Solved

Count of Grouped Records

Posted on 2013-06-04
4
287 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Direct Mail software 4 43
Auto Filter in Combo Box 7 33
Track name AutoCorrect info 14 47
how to address a subform in a form, from inside another subform 2 24
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now