Like Parameters

  • Thread starter Thread starter phuser
  • Start date Start date
P

phuser

I have created a form that allows the user to type in "like" parameters in
text fields, however all fields must contain data in order for the
parameters to bring up data, I would like it so that if any of the fields
are blank that it would only use the one that actually has something in it
and the rest would contain no parameters. Is that possible?
 
Try someting like

Select * From TableName
Where
FieldName Like Nz(Forms![FormName]![FieldName] ,"*")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form/Subform with Parameter 2
Parameter Form - Combo Box - Parameter Query - Report Problems 1
Enter Parameter Value in Access Form 0
Search using "LIKE" and choosing one record from multiple matches 3
Date parameters for report 2
Enter parameter value 2
Creating a form using multiple parameters 1
forcing blank in combo box 2

Back
Top