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

    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
    Location
    Préverenges, Switzerland
    Posts
    3,740
    lost:

    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.

    izy
    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
  •