Query sort any one from three

[neptunes]

Hi i have a text box [assigned to] with a input mask ??\-??\-?? this is in a form the idea is to put initials in for staff working on a job. On a report it would look like po-as-bb i would like to create a query so that when a single initial is input it searches through the three and shows the result if po is entered in any of the three sections if i just put [name] in the criteria section of the query it only selects the first initial. Any help would be great cheers

 

[Remou]

You can use like with a wildcard:

Like "*" & [Enter Name] & "*

 

[neptunes]

Brill thank you Remou just what i was looking for