Query a field to find an asterisk in the field

  • Thread starter Thread starter Mark Stewart
  • Start date Start date
M

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
 
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
Click to expand...

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 "[*]*"
 
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
Click to expand...

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.
.
Click to expand...
 
Back
Top