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?
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?
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.