<div>
So this would be acceptable:<br />
<br />
BEARING BALL-<br />
<br />
?<br />
<br />
/gustav
</div>


So this would be acceptable:

BEARING BALL-

?

/gustav

<div>
Hi<br />
<br />
Not quite, I want to exclue the data record where the description starts with a word proceeded with the &quot;-&quot;<br />
<br />
Hope this makes sense<br />
<br />
Gordon
</div>


Hi

Not quite, I want to exclue the data record where the description starts with a word proceeded with the "-"

Hope this makes sense

Gordon

<div>
Then you could use:<br />
<br />
.. Where InStr([Description], &quot;-&quot;) &lt;= InStr([Description], &quot;&nbsp;&quot;)<br />
<br />
/gustav
</div>


Then you could use:

.. Where InStr([Description], "-") <= InStr([Description], " ")

/gustav

<div>
Hi<br />
Trying you suggestion it comes up with invalid syntex<br />
Gordon
</div>


Hi
Trying you suggestion it comes up with invalid syntex
Gordon

<div>
Of course. That what just the criteria part. <br />
Don't know your query. A minimum would be:<br />
<br />
Select * From tblYourTable Where InStr([Description], &quot;-&quot;) &lt;= InStr([Description], &quot;&nbsp;&quot;)<br />
<br />
Replace with your actual table and field name.<br />
<br />
/gustav
</div>


Of course. That what just the criteria part.
Don't know your query. A minimum would be:

Select * From tblYourTable Where InStr([Description], "-") <= InStr([Description], " ")

Replace with your actual table and field name.

/gustav

<div>
Hi<br />
<br />
I put this as a SQL statement Ok<br />
<br />
But it is not excluding where the first work is proceeded with the -<br />
ie OEM-<br />
<br />
Gordon
</div>


Hi

I put this as a SQL statement Ok

But it is not excluding where the first work is proceeded with the -
ie OEM-

Gordon

<div>
Hi<br />
<br />
It works<br />
Thanks<br />
Gordon
</div>


<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
I would like to create a query which will exclude data that has an &quot;-&quot; after the first word in a description field<br />
ie:-<br />
BEARING-BALL<br />
OEM-<br />
PUMP-<br />
<br />
Gordon
</div>
</div>


Hi
I would like to create a query which will exclude data that has an "-" after the first word in a description field
ie:-
BEARING-BALL
OEM-
PUMP-

Gordon

Exclude Data from Query

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.