|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 17th, 2008, 04:53 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Query an Asterisk in the description
Some of our product descriptions have an asterisk in the description to flag
those products. How do I query all the products that have an asterisk in the description while using the asterisk as a wildcard? 
|
|
#2
July 17th, 2008, 05:03 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Query an Asterisk in the description
Enclose it in square brackets:
Like "*[*]*" -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Scott" wrote in message ... Some of our product descriptions have an asterisk in the description to flag those products. How do I query all the products that have an asterisk in the description while using the asterisk as a wildcard?
|
|
#3
July 17th, 2008, 05:07 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Query an Asterisk in the description
Use a calculated field searching for the Ascii code 42 like this --
Expr1: InStr([YourField], Chr(42)) Use 0 as criteria. -- KARL DEWEY Build a little - Test a little "Scott" wrote: Some of our product descriptions have an asterisk in the description to flag those products. How do I query all the products that have an asterisk in the description while using the asterisk as a wildcard?
|
|
#4
July 17th, 2008, 05:15 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Query an Asterisk in the description
Worked perfectly! Thank you!
"Allen Browne" wrote: Enclose it in square brackets: Like "*[*]*" -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Scott" wrote in message ... Some of our product descriptions have an asterisk in the description to flag those products. How do I query all the products that have an asterisk in the description while using the asterisk as a wildcard?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
