Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Random number for invoice

    I am doing an invoice for some coursework i am doing and am trying to get a reandom number to display at the minute i have created another table set invoice number to random number entered it into the query i am using. I then open this in a report and all the detials come up. But with invoice number nothing comes up. Can anyone help. I need it so the number increses every time i open a invoice can anyone help.

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland

    you want a random number that increases each time: that is definitely not "random" behaviour!.

    if you want a unique and random number, you can achieve this with autonumber. set the autonumber new value property to "random" (instead of the default "increment") when you design the table.

    currently using SS 2008R2

Posting Permissions

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