Form based query

[sharonir22]

Hi
I have a table that stores people information with their id and name.
In the table the name is devided into 4 fields: first name, father's name, grandfather's name and last name.


I have a search form where you can enter the name in 4 fields to search for similar names on the table.

I want the query to be able to search for an exact match of fields in case the fields is filled and for any record in case it's empty .
For example if the user enterd jack in the first name field and smith in the last name field and left the 2 others empty, the query will find all the people who's first name is jach and last name's smith.

What sould i use as a criteria on my query?

And also is there a way that the query can look for similar names? Like if someone writes john it will also find jon? Or johnathan?

Tnx alot this place is saving me

[orange]

You might get some ideas from this Allen Browne article or maybe this one or this one for Fuzzier matches.