I have a query that prompts for a name and then searches for all records that have that name.How do i make it so that it returns all records that have just part of what was typed in in the name field.

For example if just "rich" was typed in all records that have "richard" would be returned?

read up on Like operator.

Like "*" & [Criteria] & "*"