Find DMax for values that begin with specific characters within a field-MS Access
Posted on 2012-03-21
Is it possible to find the DMax for a group of values that begin with specific characters?
Example: Let's say I have the following values in a table called Table1 and stored in field called Field1. I know that DMax("Field1", "Table1") will return the maximum value (N060006) for all values in Field1, but what would I need to do if I wanted to return the DMax value for only the values in Field1 that start with N05? Is this possible?
I appreciate any suggestions that anyone may have.