DasaniDrinker
IS-IT--Management
There is probably an easy solution for this but I just can't see it. So here goes..
I have a table with following fields (among other fields):
Firstname
Middlename
Lastname
NameSuffix
<and yes... my client wants them separate>
From my Form I want to be able to search by full name. Everything I try requires me to type in a space for each field that has 'no' data.
For example, I have a person named John Will Doe.
When I search for John Will Doe, it will not find the name, unless i put a space after Doe (for the missing NameSuffix, which is blank in the table). I have tried by using a hidden field on my form which has the entire name concatenated together. I have also tried combining the names in a query first, but the same result. My FIND box is set to "any part of field".
There must be an obvious solution I am overlooking. Please help if you can. Surely someone has seen this type of problem before.
Thanks,
DasaniDrinker
I have a table with following fields (among other fields):
Firstname
Middlename
Lastname
NameSuffix
<and yes... my client wants them separate>
From my Form I want to be able to search by full name. Everything I try requires me to type in a space for each field that has 'no' data.
For example, I have a person named John Will Doe.
When I search for John Will Doe, it will not find the name, unless i put a space after Doe (for the missing NameSuffix, which is blank in the table). I have tried by using a hidden field on my form which has the entire name concatenated together. I have also tried combining the names in a query first, but the same result. My FIND box is set to "any part of field".
There must be an obvious solution I am overlooking. Please help if you can. Surely someone has seen this type of problem before.
Thanks,
DasaniDrinker