DMax with LIKE in criteria

[tylerg11]

Hello,

I have the following DMax function and I want to use LIKE criteria in the criteria portion of the function. Specifically I want to return the max project number of all project numbers that begin with '2013'. The following function isn't working though.

DMax("ProjectNumber", "Projects","ProjectNumber like '2013%'")

[pbaldy]

Never tried it, but likely the wildcard would need to be *. Try:


DMax("ProjectNumber", "Projects","ProjectNumber like '2013*'")

[tylerg11]

That didn't work. It works if I eliminate any wildcard characters and actually use the entire value, but I'm wanting to use a 'begins with' filter in the criteria portion of the DMax function.

[pbaldy]

I set up a brief test and this worked as expected:

Dmax("textfield","tblData","textfield like '2013*'")

[tylerg11]

I think I left some extra brackets in my code by mistake because that worked! Thanks!

[pbaldy]

Happy to help!