Results 1 to 13 of 13

Thread: Running Totals (s.no) - Report - Access 2003

Threaded View

  1. 03-05-2009, 05:05 AM #1
    Ignorant's Avatar
    Ignorant
    Ignorant is offline Registered User
    Join Date
    Aug 2008
    Posts
    29

    Unhappy Running Totals (s.no) - Report - Access 2003

    Hi,
    Iam having trouble adding s.nos to the group header.
    The group header has one or more rows in them. I want to have a s.no incremented only on the group header, ignoring the records it contains.
    I added a textbox and set the control souce to =count([Member]![fName]) and set the running sum to Over group.
    But it starts counting the GH+REC1+REC2+REC3...
    So if first group has 2 records, the next group has s.no. 4?!? i.e GH+REC1+REC2.
    Iam attaching a sample proj for your examination.

    Have a look at the Tables & Quries as well

    Thanks in advance...
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules