Query a field to find an asterisk in the field

[Mark Stewart]

Hello,

I get data provided that I need to query out some records.
The field to query is a text field and has names in it, ie:

Bob Smith
Jane Doe
Rodney Jones*

I need to filter to only get the ones with the asterisk.
I've tried building a formula, but I think Access sees
the "*" and wants to treat it like a wildcard.

It could be I should use the "Right" function but I'm not
sure of the syntax so that it doesn't think I'm looking
for a wildcard.

Thanks...I'm sure it's simple, but beyond me.

Thanks you,
Mark

 

[fredg]

Hello,

I get data provided that I need to query out some records.
The field to query is a text field and has names in it, ie:

Bob Smith
Jane Doe
Rodney Jones*

I need to filter to only get the ones with the asterisk.
I've tried building a formula, but I think Access sees
the "*" and wants to treat it like a wildcard.

It could be I should use the "Right" function but I'm not
sure of the syntax so that it doesn't think I'm looking
for a wildcard.

Thanks...I'm sure it's simple, but beyond me.

Thanks you,
Mark

Place the asterisk within brackets.

Asterisk anywhere in the field
Like "*[*]*"
or..
In the last position only
Like "*[*]"
or

In the first position only
Like "[*]*"

 

[Mark Stewart]

THANK YOU!!! Works like a charm...but you knew it
would. Again, Thanks!

-----Original Message-----

Hello,

I get data provided that I need to query out some records.
The field to query is a text field and has names in it, ie:

Bob Smith
Jane Doe
Rodney Jones*

I need to filter to only get the ones with the asterisk.
I've tried building a formula, but I think Access sees
the "*" and wants to treat it like a wildcard.

It could be I should use the "Right" function but I'm not
sure of the syntax so that it doesn't think I'm looking
for a wildcard.

Thanks...I'm sure it's simple, but beyond me.

Thanks you,
Mark

Place the asterisk within brackets.

Asterisk anywhere in the field
Like "*[*]*"
or..
In the last position only
Like "*[*]"
or

In the first position only
Like "[*]*"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.