Smart Search multiple fields?

[Deisun]

Hey guys not sure if this belongs in the programming section or query section.

If I wanted my searchbox to be able to search not only individual fields but also combinations of those fields together, would that involve using concatenation on a SQL query of the fields?

For instance:

Right now I have 3 fields: First Name, Last Name, Phone #

Right now I can search for "James" and find all the James' in my table.
However, if I search for "James Brown", I want to be able to find him....but that uses 2 different fields. What should I look at to do this? Having the SQL query concatenate the First and Last name fields together?

[NTC]

in query design you would put the criteria 'James' in both columns but in differing rows....this makes it an OR query.....

be sure to get yourself an Access textbook available from Amazon or any large bookstore as this will cover such things for you and alot more....

[apr pillai]

For multiple field search you have rightly guessed the solution. Take a look at the following Article on this subject:

Text Search Filter Web Style