<div>
Rather than use the LIKE or IN operators, which are notoriously slow, I would do something similar to:<br />
<br />
WHERE (Left([FieldName],2) = &quot;13&quot; OR Left([FieldName],2) = &quot;14&quot;) <br />
AND (Right([FieldName], 1) = &quot;T&quot; OR Right([FieldName], 1) = &quot;A&quot; OR Right([FieldName], 1) = &quot;M&quot; OR Right([FieldName], 1) = &quot;B&quot; OR Right([FieldName], 1) = &quot;F&quot;)<br />
<br />
Depending on the size of your recordset, this would probably be much more efficient.
</div>


Rather than use the LIKE or IN operators, which are notoriously slow, I would do something similar to:

WHERE (Left([FieldName],2) = "13" OR Left([FieldName],2) = "14")
AND (Right([FieldName], 1) = "T" OR Right([FieldName], 1) = "A" OR Right([FieldName], 1) = "M" OR Right([FieldName], 1) = "B" OR Right([FieldName], 1) = "F")

Depending on the size of your recordset, this would probably be much more efficient.

<div>
<div class="content wysiwyg-content">
I have a field in a query that has a long criteria, is there a way to shorten it?<br />
<br />
Current Criteria:<br />
<br />
Like &quot;13-*T&quot; Or Like &quot;13-*A&quot; Or Like &quot;13-*M&quot; Or Like &quot;13-*B&quot; Or Like &quot;13*F&quot; Or Like &quot;14-*T&quot; Or Like &quot;14-*A&quot; Or Like &quot;14-*M&quot; Or Like &quot;14-*B&quot; Or Like &quot;14*F&quot;<br />
<br />
The numbers are the year.
</div>
</div>


I have a field in a query that has a long criteria, is there a way to shorten it?

Current Criteria:

Like "13-*T" Or Like "13-*A" Or Like "13-*M" Or Like "13-*B" Or Like "13*F" Or Like "14-*T" Or Like "14-*A" Or Like "14-*M" Or Like "14-*B" Or Like "14*F"

The numbers are the year.

Access 2007 Criteria

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.