Partial information queries

[NOLI QASUP]

I would like to create a query that when prompted the user only has to put in
partial information. I understand you can use wildcards that will search for
a defined items like b[ae]ll. I would like not to have to match every digit
or letter in the field.

 

[Ken Snell \(MVP\)]

If the user would enter consecutive letters that can be anywhere within the
value:

SELECT * FROM TableName
WHERE FieldName Like "*" &
[Enter partial letters to find:] & "*";

 

[John Spencer]

Perhaps you could give a few concrete examples of what you are looking
for when you say "partial" information.

If you want to find records that have a string anywhere in the field,
the criteria might be

Like "*" & [Find What?] & "*"

That will find records with the following
Will
William
I will do that
Wee Willie Winkle
it tastes like swill
if the user types "will" in the parameter prompt.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================