Results 1 to 4 of 4
  1. 07-28-2006, 04:56 PM #1
    MeehPhill
    MeehPhill is offline Novice
    Join Date
    Jul 2006
    Posts
    2

    Need Help on reports

    I'm creating a report, and I have it sorted by Total.

    Now it need either a formula for autonumbering or Rank..

    do anyone know the formula?

    is there a site ?
    Reply With Quote Reply With Quote
  2. 07-29-2006, 06:00 AM #2
    matthewspatrick
    matthewspatrick is offline Competent Performer
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    One simple way is to modify the query that the report draws on to have a "dummy" field whose value is always 1. Then, in your report, set the Running Total property for that dummy field to 'over all' or 'over group' as your needs dictate.
    Reply With Quote Reply With Quote
  3. 07-31-2006, 11:28 AM #3
    MeehPhill
    MeehPhill is offline Novice
    Join Date
    Jul 2006
    Posts
    2
    Thank you Patrick, that help.
    Reply With Quote Reply With Quote
  4. 07-31-2006, 11:51 AM #4
    matthewspatrick
    matthewspatrick is offline Competent Performer
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    You're most welcome.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« 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

Other Forums: Microsoft Office Forums