Results 1 to 3 of 3
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919

    Trying unsuccessfully to use LIKE in DMax function




    DMax doesn't seem to recognize the use of "LIKE" in the criteria expression. Is it not supported in such context?

    Code:
    varLastPayID = DMax("TRecID", "QRegister", "Description = 'LIKE Verizon*'")

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,412
    try

    "Description LIKE 'Verizon*'"

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    Thanks Ajax, that worked perfectly.
    Bill

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

Similar Threads

  1. DMax function Help
    By AgentLozen in forum Access
    Replies: 3
    Last Post: 04-09-2018, 12:09 PM
  2. VBA DMax function
    By edson in forum Access
    Replies: 9
    Last Post: 01-31-2015, 10:11 AM
  3. ?? on DMAX function
    By eliotchs in forum Programming
    Replies: 4
    Last Post: 07-28-2014, 03:35 PM
  4. Dmax/Val function Problem
    By MintChipMadness in forum Programming
    Replies: 8
    Last Post: 08-13-2012, 08:50 AM
  5. using a qry to run a report with Dmax Function
    By mrjoshuaw in forum Access
    Replies: 6
    Last Post: 02-01-2012, 07:29 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