Results 1 to 4 of 4
  1. #1
    shabbaranks is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Oct 2011
    Posts
    162

    Adding "1" onto a query - is it possible>?

    Hi all,



    I've got a query which selects the highest number within a column, but what I am trying to do is add 1 onto it -can anyone tell me if this is possible within the QBE? Or even within an SQL statement?

    Thanks

  2. #2
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    Hi,
    Your thread appears as solved.
    Can I request sharing the solution for other users benefit.

    Thanks

  3. #3
    shabbaranks is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Oct 2011
    Posts
    162
    Sorry... I didnt use the query builder in the end I used dmax and then added 1 on the end

    Code:
    Me![PO No] = DMax("val([No])", "Purchase No") + 1

  4. #4
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    Thanks for sharing.
    I was thinking somewhere along the lines of

    SELECT Max(Table1.testNumber)+1 AS MaxOftestNumber
    FROM Table1;

    Once again Thanks for Sharing.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Adding "Open" column to Query Result
    By premis in forum Queries
    Replies: 12
    Last Post: 05-30-2012, 03:47 PM
  2. Replies: 4
    Last Post: 04-07-2012, 02:33 PM
  3. Replies: 11
    Last Post: 03-29-2012, 02:32 PM
  4. Replies: 16
    Last Post: 07-22-2011, 09:23 AM
  5. Replies: 4
    Last Post: 12-03-2010, 04:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums