Wanting to search for a name based on input

[bartiks]

Hello all,


I've got 2010 and what I have is a training database. Names, dates and companies, I can search for either their name or their company. However it has to be an exact match in order for it to pull up their record out of the table.

Is there a way to type in what you remember and then it will return all relevant entries in the table? Say I want to look for John Doe, but I forgot his last name. Could I run a search on the table for John and it returns all John's within the table? Any help would be greatly appreciated.

My apologies for my lack of knowledge in this. I had some help getting this setup around 6 years ago and wanting to update it a little to make it a little more use friendly. Thanks in advance.

[pbaldy]

How are you doing it (code, query, etc)? Generally, you use Like instead of = and include wild card characters before and/or after the value depending on your needs:

Like "John*"

would find anything starting with John, but not Elton John.

[moke123]

In addition to Pauls advice, it depends how complicated you want to get. For instance a search for John wont turn up Jon.
If you want a code solution you can add procedures such as the levenschtein distance or soundex to correct spelling mistakes.
see the example in this post...https://www.accessforums.net/showthr...362#post423362