Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    tazzzz is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2015
    Location
    USA
    Posts
    37
    This is what I did wrong:I forgot "" from[PRODUCTION DATE](see bellow)
    WHERE [PRODUCTION DATE]>DMax("[PRODUCTION DATE]", "FullData");


    Now it's working.
    Thank you so much for the help.

    How should I mark this one as solved?

  2. #17
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Domain aggregate function arguments must be in quote marks.

    DMax("[PRODUCTION DATE]", "FullData");
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to copy data within the same table?
    By price12 in forum Access
    Replies: 1
    Last Post: 04-23-2014, 08:34 PM
  2. Replies: 13
    Last Post: 11-14-2013, 04:13 PM
  3. Replies: 6
    Last Post: 05-23-2013, 08:14 AM
  4. Replies: 3
    Last Post: 03-05-2013, 05:14 AM
  5. copy data from one table to another
    By Sureshbabu in forum Access
    Replies: 1
    Last Post: 01-08-2012, 01:27 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