Results 1 to 2 of 2
  1. 11-17-2012, 10:06 PM #1
    rkalapura
    rkalapura is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    New York
    Posts
    69

    DMax() with date


    I need to track the latest record entered in a table by the latest date. Is it right to use dmax() function with date. I am not getting the right syntax for it.

    Dmax["[orddate]","[order]","[partno]"='"&[forms]![order]![partno]&"'")

    Will this give me the latest order date of the part number?

    Thanks for your help.
    Reply With Quote Reply With Quote
  2. 11-17-2012, 11:17 PM #2
    June7's Avatar
    June7
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    That looks good to me, assuming partno is a text datatype field.
    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.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. How to filter last date using Dmax
    By glen in forum Reports
    Replies: 4
    Last Post: 11-12-2012, 09:45 AM
  2. DMAX in VBA
    By Meanfish in forum Access
    Replies: 1
    Last Post: 11-03-2012, 11:06 AM
  3. Can you use Dmax and the group by clause or dmax with multiple criteria?
    By schwachmama in forum Queries
    Replies: 6
    Last Post: 07-24-2012, 03:02 PM
  4. How to use DMAX
    By tomneedshelp in forum Access
    Replies: 2
    Last Post: 03-01-2012, 07:22 AM
  5. Using Nz and Dmax
    By timmy in forum Programming
    Replies: 5
    Last Post: 07-04-2011, 06:42 AM

Tags for this Thread

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums