Hi all. If this could be solved, it would be a major breakthrough for my dbman. Any help is very much appreciated!

What I want to do is:

When a search is done on three fields at once, I want results from all three fields to be "thrown together" and listed alphabetically.

For example, if I have RealName, Nickname1 and Nickname2, I'd like to be able to search all three, and then display the results as if they were all the same field. So the search results might look like:

Al
Albert
Michael
Micky
Mike

..even though the results all came from different fields. Please help. Thank you.