access query

S

seth

how do i create a query which will pull up a list of matching records. for
ex: If i enter "main street" in the address field it should list all the
records that contain "main street".
then i want to create a form to display this data?
 
T

tina

try adding the following criteria to the address field in query Design view,
as

Like "*" & [Enter a partial street address.] & "*"

when you run the query, an input box will pop up showing the instructions
you put within the brackets [ ].

to use the query in a form, you can bind the form to the query, and put an
unbound textbox control in the form's Header section, where the user can
type the partial address. add a command button to requery the form. in the
query, change the criteria above to

[Forms]![FormName]![TextboxName] Or [Forms]![FormName]![TextboxName] Is Null

add the above all on one line in the query criteria grid, and replace
FormName and TextboxName with correct names of those two objects, of course.

hth
 
Top