Creating Access Form
I have a table where I want to query partial phrases or words and cannot figure out a simple way to accomplish this. I used the brackets [] in the underlying query but cannot figure out an easy way to retrieve data with partial info.
Software/Hardware used:
Software/Hardware used:
ASKED:
January 7, 2011 7:37 PM
UPDATED:
January 10, 2011 2:32 PM
Answer Wiki:
Use the Like statement with the wild card operator *
Ex. Find all rows where field1 has a word that starts with "con"
Select * from table where field1 like "con*"
Ex. Find all rows where field1 has a word that has "con" anywhere in the word
Select * from table where field1 like "*con*"
Ex. Find all rows where field1 has a word that ends with "con"
Select * from table where field1 like "con*"
To see all answers submitted to the Answer Wiki: View Answer History.
That last one should have been
Ex. Find all rows where field1 has a word that ends with “con”
Select * from table where field1 like “*con”