Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2003
    Location
    Perth, Western Australia, Australia
    Posts
    150
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Incrementing in Reports (2000)

    Hi guys,
    In reports, how do I create an incremental field. In which for every total transactions for each report, that is the customer invoice. It will have a text field that will increment 200002824, 200002825,200002826 etc etc.
    The report retrieves the data from tblManifest. Which is a table of transactions and the report summarises that for each
    customer. Each invoice should have an incremental invoice no. But i dont have a field in tblManifests for invoice no, i didnt know if that should be done.
    This is quite urgent
    Thankyou in advance.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Incrementing in Reports (2000)

    It seems to me that creating such an incrementing number on the report will not be too terribly useful. The problem, at least as I see it, is that each time you run the report (depending on what has been done to the table since the last report), the numbers may not related to the same records anymore. That is 2000285 on one report may not be the same record as 2000285 the next time you run the report.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Incrementing in Reports (2000)

    It appears to me that you need a table for Invoices. That is the logical place for your incremental number.
    Charlotte

Posting Permissions

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