Wilcard Question

[Guest]

Dear All

I have a field called Name which has the following values:

*Old Rec
* Newer Rec
New Record

How can I query the name field to not display the records with an *? This is
a problem when the * is also a wildcard.

Criteria: "**"

Confused!

Thanks again.

Alastair MacFarlane

 

[Guest]

Dear All,

A colleague advised me that the answer was to replace the * with a ^ and it
will work. Indeed it does!

Thanks again for reading this post.

Alastair

 

[John Spencer]

Pardon me.

Do you mean that you changed the criteria to
Like "^*"
or did you change the values in the fields?

If the former, then I have learned something new. Thanks.

I was going to advise that you use one of the following as the criteria.
Like "[!*]*"

or
Not Like "[*]*"

 

[Guest]

John,

It was the former and I have learnt from you that there is more than one way
to achieve the desired result.

Thanks again for the post.

Alastair

Pardon me.

Do you mean that you changed the criteria to
Like "^*"
or did you change the values in the fields?

If the former, then I have learned something new. Thanks.

I was going to advise that you use one of the following as the criteria.
Like "[!*]*"

or
Not Like "[*]*"

Dear All,

A colleague advised me that the answer was to replace the * with a ^ and
it
will work. Indeed it does!

Thanks again for reading this post.

Alastair

 

[Guest]

One other thing to learn today. A field should not be named Name. It is a
reserved Access word and can confuse Access. It would be a good idea to be
sure you know what words not to use (Name, Date, Oct, etc.) or better still,
use a naming convention that would preclude an accidental naming confilct.

John,

It was the former and I have learnt from you that there is more than one way
to achieve the desired result.

Thanks again for the post.

Alastair

Pardon me.

Do you mean that you changed the criteria to
Like "^*"
or did you change the values in the fields?

If the former, then I have learned something new. Thanks.

I was going to advise that you use one of the following as the criteria.
Like "[!*]*"

or
Not Like "[*]*"

Dear All,

A colleague advised me that the answer was to replace the * with a ^ and
it
will work. Indeed it does!

Thanks again for reading this post.

Alastair
:

Dear All

I have a field called Name which has the following values:

*Old Rec
* Newer Rec
New Record

How can I query the name field to not display the records with an *? This
is
a problem when the * is also a wildcard.

Criteria: "**"

Confused!

Thanks again.

Alastair MacFarlane

 

[John Spencer]

Hmm, I tried your method and it failed for me. What version of Access are
you using? Are you using a native Access mdb (Jet) as the data store? Or
are you querying against some other data engine?

John,

It was the former and I have learnt from you that there is more than one
way
to achieve the desired result.

Thanks again for the post.

Alastair

Pardon me.

Do you mean that you changed the criteria to
Like "^*"
or did you change the values in the fields?

If the former, then I have learned something new. Thanks.

I was going to advise that you use one of the following as the criteria.
Like "[!*]*"

or
Not Like "[*]*"


"Alastair MacFarlane" <[email protected]>
wrote
in message news:[email protected]...

Dear All,

A colleague advised me that the answer was to replace the * with a ^
and
it
will work. Indeed it does!

Thanks again for reading this post.

Alastair
:

Dear All

I have a field called Name which has the following values:

*Old Rec
* Newer Rec
New Record

How can I query the name field to not display the records with an *?
This
is
a problem when the * is also a wildcard.

Criteria: "**"

Confused!

Thanks again.

Alastair MacFarlane