<div>
Thanks fyed. &nbsp;That's exactly what I was looking for.<br />
<br />
Have a good day.
</div>


Thanks fyed.  That's exactly what I was looking for.

Have a good day.

<div>
<div class="content wysiwyg-content">
Is it possible to find the DMax for a group of values that begin with specific characters?<br />
<br />
Example: &nbsp;Let's say I have the following values in a table called Table1 and stored in field called Field1. I know that DMax(&quot;Field1&quot;, &quot;Table1&quot;) 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? &nbsp;Is this possible?<br />
<br />
N040012<br />
N040013<br />
N050001<br />
N050002<br />
N050009<br />
N060004<br />
N060005<br />
N060006<br />
<br />
I appreciate any suggestions that anyone may have.
</div>
</div>


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?

N040012
N040013
N050001
N050002
N050009
N060004
N060005
N060006

I appreciate any suggestions that anyone may have.

Find DMax for values that begin with specific characters within a field-MS Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.