Prev: How to query
Next: A bug in GUI of creating query with more outer joins betweentwo t
From: Bateman28 on 24 Mar 2010 08:01
Hi

I am trying to use a delete query where any records that contain the Word
Proprietor is removed. In My current table there are hundreds of records
within a "Customer Name" field where the names are for example:

Mr T Proprietor
Mr D Proprietor
Mr C Proprietor

I Would like to delete all of the records that contain the word "Proprietor"
as these are records that are not used. I have tried a Like "Proprietor*"
Query But this didn't work. If anyone could help it would be great

Cheers
From: Krzysztof Naworyta on 24 Mar 2010 08:17
Juzer Bateman28 <Bateman28(a)discussions.microsoft.com> napisał
| Hi
|
| I am trying to use a delete query where any records that contain the
| Word Proprietor is removed. In My current table there are hundreds of
| records within a "Customer Name" field where the names are for example:
|
| Mr T Proprietor
| Mr D Proprietor
| Mr C Proprietor
|
| I Would like to delete all of the records that contain the word
| "Proprietor" as these are records that are not used. I have tried a
| Like "Proprietor*" Query But this didn't work. If anyone could help it
| would be great


Like "Proprietor*"
if you want to delete every record with field that STARTS with
"Proprietor"

Like "*Proprietor"
if you want to delete every record with field that ENDS with "Proprietor"

Like "*Proprietor*"
if you want to delete every record with field that contains "Proprietor"


--
KN

From: Petr Danes on 24 Mar 2010 08:18
The phrase Like "Proprietor*" selects only those records where the word
Proprietor is at the beginning of the field.

If you want all records that contain the word Proprietor at the end of the
field, use Like "*Proprietor".

If you want all records that contain the word Proprietor anywhere in the
field, use Like "*Proprietor*".

Pete



"Bateman28" <Bateman28(a)discussions.microsoft.com> p�e v diskusn�m p��sp�vku
news:94D4AF85-A2AD-4642-9A2B-BE54A21DB021(a)microsoft.com...
> Hi
>
> I am trying to use a delete query where any records that contain the Word
> Proprietor is removed. In My current table there are hundreds of records
> within a "Customer Name" field where the names are for example:
>
> Mr T Proprietor
> Mr D Proprietor
> Mr C Proprietor
>
> I Would like to delete all of the records that contain the word
> "Proprietor"
> as these are records that are not used. I have tried a Like "Proprietor*"
> Query But this didn't work. If anyone could help it would be great
>
> Cheers


From: Bateman28 on 24 Mar 2010 09:03
Thanks to both of you for the quick response, i had a feeling i was being
stupid, thats great

Cheers

"Petr Danes" wrote:

> The phrase Like "Proprietor*" selects only those records where the word
> Proprietor is at the beginning of the field.
>
> If you want all records that contain the word Proprietor at the end of the
> field, use Like "*Proprietor".
>
> If you want all records that contain the word Proprietor anywhere in the
> field, use Like "*Proprietor*".
>
> Pete
>
>
>
> "Bateman28" <Bateman28(a)discussions.microsoft.com> pí¹e v diskusním pøíspìvku
> news:94D4AF85-A2AD-4642-9A2B-BE54A21DB021(a)microsoft.com...
> > Hi
> >
> > I am trying to use a delete query where any records that contain the Word
> > Proprietor is removed. In My current table there are hundreds of records
> > within a "Customer Name" field where the names are for example:
> >
> > Mr T Proprietor
> > Mr D Proprietor
> > Mr C Proprietor
> >
> > I Would like to delete all of the records that contain the word
> > "Proprietor"
> > as these are records that are not used. I have tried a Like "Proprietor*"
> > Query But this didn't work. If anyone could help it would be great
> >
> > Cheers
>
>
> .
>
 | 
Pages: 1
Prev: How to query
Next: A bug in GUI of creating query with more outer joins betweentwo t