I have a table with each record representing a team. The teams can be made up of several individuals so an individual may show up in record three and record ten. Their position on the team also rotates so they may be in position A in record three and position C in record ten. I need to be able to create a query that will allow the user to enter a name in a form and have the query search each record and positon and retrieve any record where the individuals name appears. I made a query and listed all the fields in the table with a like criteria in each; however, I never got a match. I am assuming the query was looking for a record where the entered name was presented in every field of a record. I really hope I explained that correctly. Thanks for your help.