Results 1 to 5 of 5
  1. #1
    alyon is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2011
    Posts
    89

    DLast

    I'm trying to use the DLast Function+1. I have the DLast working as the last number pops up, but it will not add the 1. I cannot use the DMax Function as I was because one entry along the way got an extra number set to it, and messes up the entire number system when using DMax.
    My code is as follows:
    =DLast("[Field]","[Table]")+1

    Any suggestions as to why the +1 isn't working?




    Thank you in advance for your help!
    Ashley Lyon

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Is the field in question a numerical field? What is the property for it in the table? If it is a text value, then you will have to convert it first.

  3. #3
    alyon is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2011
    Posts
    89
    Yes, it's a numerical field. The field within the table is set to number and the text box is set to general number format.

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    If you remove the +1 do you get the correct result for DLast?

  5. #5
    alyon is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2011
    Posts
    89
    Apparently, it is working on everyone else's computer just not mine. So problem solved! :]

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

Similar Threads

  1. Replies: 2
    Last Post: 11-08-2012, 05:22 AM
  2. Replies: 0
    Last Post: 03-14-2012, 07:23 AM
  3. vba Dlast for each page!
    By Ivanho in forum Reports
    Replies: 0
    Last Post: 11-23-2011, 04:27 AM

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