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] ,"*")
 
Back
Top