 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2006Getting the Count of Record in a Group
How does one go about getting a count of the number of items in a group to put in the group header or group footer. (If it is possible at all!) I started down the path of DCOUNT, but when the criteria simply has a test to see if a field is equal to itself, which sort of makes sense, but won't work. Thanks! Don in the group header or footer section, add an unbound textbox control. in the control's ControlSource property, enter the following expression, as =Count([FieldName]) substitute the correct name of a field in the detail section of the report. hth > How does one go about getting a count of the number of items in a group to > put in the group header or group footer. (If it is possible at all!) I [quoted text clipped - 5 lines] > > Don Thanks Tina!! A little too much target fixation on DCOUNT! Don > in the group header or footer section, add an unbound textbox control. in > the control's ControlSource property, enter the following expression, as [quoted text clipped - 17 lines] >> >> Don |
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.