Multiple columns filter results

[Ruegen]

I have a table with multiple name columns - name1, name2, name3

is it possible to construct a list of those names into one column



ie.e
ID Name
3 sam jones(name1)
2 sam (name2)
17 sam smith (name3)

and then filter that constructed list through an unbound text box?

note: so far I am using a drop down that changes the record source to allow me to requery the list with the different column as the filtered name column - so when you change it to name2 then all the column shows is name2 columns, then filter that.

[ItsMe]

I am not sure I follow what is in your note. As for the first part of your post, yes. I do it often for grouping in reports. Really, it is fairly simple. Create an alias in a SELECT query that concatenates the multiple fields.