Results 1 to 4 of 4

Thread: Access Question

  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Frederick, Maryland, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Question

    I am developing a procurement database system. On a particular form, I want to give the user the option to press a button to auto-generate a new purchase requisition number. The new PR number would have to equal (the current highest PR number in the SUBINFO table + 1). Is there an easy way to do this?

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Question


  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Question

    I would use something like:<pre>=DMax([SUBINFO])+1</pre>


  4. #4
    EPY6323
    Guest

    Re: Access Question

    Just be careful with concurrent users, two of them could get the same number if the new record isn't saved "quick enough"

Posting Permissions

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