Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2009
    Posts
    2

    Red face Unanswered: report needs unique number

    Hi

    I would appreciate some help with a something I’m trying to do in access.

    I'm a self taught user of access so please excuse me if I don't explain myself very well.

    I have created a database to record education visits - some of this visit will need to be invoiced but not all. Within the education visit form (linked to a table) i have a text lookup Yes/No for the question 'is invoice required'.

    What i want it do is if the answer to the question is yes it will generate a number, sequential from the last number from a yes answer. If the answer i no i don't want it assigned a number.

    I want this number so that i can use it as an invoice number on a report which i have created to be an invoice.

    I may be going about this all the wrong way though.

    Please, if you can offer a solution can you write it in an idiots guide as i am still learning and quite a lot of the correct terminology passes me by.

    Thanks

    Sorry forgot to say I'm using MS Access 2003
    Last edited by self taught; 01-29-09 at 12:36.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so you need a table with invoice numbers in, so you can grab the next invoice number
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Why not just assign a Max + 1? I see no need for an invoice number table.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so how do you know what the last used number was.
    its quite possible that you could store a number in say a general config table. but that raises problems of its own.

    the issue as I see it is that you don't 'generate' an invoice every tme the report is run. there has to a mechanism which stores the last used number (or the next available number). to me when the term 'invoice' is sued that means you need soem mechanism to review or reprint an invoice.
    ...because the post lost the last invoice (yeah right)
    ...you need to send a duplicate as a reminder, or you need the invoice numbers to allocate cash against/generate statements.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jan 2009
    Posts
    2
    Thanks for your replies.

    The invoice report runs off a query based on a 'yes' response to whether an invoice is needed or not. The report only produces invoices for this yes response.

    A unique number for each invoice is needed for our financial tracking system.

    I did create a invoice number table but didn't manage to link it in the right way as i ended up with 3000 records for 3 invoices????

Posting Permissions

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