Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Variable Number of Input Parameters Select Statement Help.....

Thread starter -
Start date Feb 27, 2001

Status: Not open for further replies.

Feb 27, 2001

Guest

I need some help creating a Select statement that will take an input of 4 fields (all of which may not be filled in all the time) and preform a search. It would be like having a First name field, and a Last name field. Then having a search that you could search by either field or both fields at the same time. Thanks to anyone that might be able to help me.....

-Matt