 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / April 2008Display counter in report for UNIQUE RECORDS
Cheers, let's say we have a report based off a query, which would yield: id Part no service performed 10 ASDF CLEAN 10 ASDF REPAIR 13 ÑLKJ CLEAN 13 ÑLKJ REPAIR I know that if I have a textbox, and if I set the control source to =1 and the runningsum property to over group it would give me a line number for each record, ie No id Part no service performed 1 10 ASDF CLEAN 2 10 ASDF REPAIR 3 13 ÑLKJ CLEAN 4 13 ÑLKJ REPAIR However, I need it to be (for clarity reasons) No id Part no service performed 1 10 ASDF CLEAN 10 ASDF REPAIR 2 13 ÑLKJ CLEAN 13 ÑLKJ REPAIR and so on... a "unique record counter" for the id field any help would be greatly appreciated thanks in advance. Yoboy I would try the following. Add a group that groups on the ID and put textbox in the group with its source as =1 and overall. Name the control txtCountID Set the visible property of the Group to No Add a control (txtShowCount) to the detail section that refers to txtCountID as its source. Set the controls hide duplicates property to Yes. I think that will work. If not, post back and we can try a variation on this where you print the group header (with all the fields that are in the detail for the first record) and don't print the first record in the detail section for each group. '==================================================== John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County '==================================================== > Cheers, > [quoted text clipped - 33 lines] > > Yoboy Mate, thanks for the reply, Did as you suggested and..... it worked! hats off!. Regards, Yoboy >I would try the following. > [quoted text clipped - 22 lines] >> >> Yoboy Sorry if this is taken as a double posting, just trying to clarify what my mate John posted earlier: "I would try the following. Add a group that groups on the ID and put textbox in the group *HEADER* with its source as =1 and overall. Name the control txtCountID Set the visible property of the Group *HEADER* to No" Hope someone makes this a sticky, ;) Regards, Yoboy >Mate, > [quoted text clipped - 15 lines] >>> >>> Yoboy |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.