<div>
HI<br />
<br />
Maybe<br />
<br />
SELECT Table1.[Field]<br />
WHERE (((Table1.[Field]) Not Like &quot;*FD##S*&quot; And (Table1.[Field]) Not Like &quot;*FD###S*&quot;));<br />
<br />
Regards
</div>


HI

Maybe

SELECT Table1.[Field]
WHERE (((Table1.[Field]) Not Like "*FD##S*" And (Table1.[Field]) Not Like "*FD###S*"));

Regards

<div>
<div class="content wysiwyg-content">
I have a table that has the following values one per record<br />
<br />
FD30, FD30S, None, FD60, FD60S, FD120 and FD120S<br />
<br />
In a query I want to filter out the records with an &quot;S&quot; on the end leaving<br />
<br />
FD30, None, FD60, &nbsp;and FD120
</div>
</div>


I have a table that has the following values one per record

FD30, FD30S, None, FD60, FD60S, FD120 and FD120S

In a query I want to filter out the records with an "S" on the end leaving

FD30, None, FD60,  and FD120

Query 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.