LillyC
asked on
Search field not pulling through all the data from my table in MS Access
Hello
I have created a search field in my form but its not bringing through all my data from the table.
I have created my table by merging 4 different tables, 1 of which was a read-only table that I thought might be the problem as one of the people I am trying to search is on that table, so I re-entered that person into the table but they still don't appear on the search - I'm baffled.
Any ideas or suggestions?
I have created a search field in my form but its not bringing through all my data from the table.
I have created my table by merging 4 different tables, 1 of which was a read-only table that I thought might be the problem as one of the people I am trying to search is on that table, so I re-entered that person into the table but they still don't appear on the search - I'm baffled.
Any ideas or suggestions?
ASKER
Hi,
Search field is just a normal combo box based on the "find the record on my form based on the value I have selected" wizard option.
Data was imported from 4 different Excel spreadsheets into a new table.
As an example, in one case, when I type surname in combo box, it brings 3 out of possible 5 people ( 2 missing live on the same address and have same second name but different first name).
Search field is just a normal combo box based on the "find the record on my form based on the value I have selected" wizard option.
Data was imported from 4 different Excel spreadsheets into a new table.
As an example, in one case, when I type surname in combo box, it brings 3 out of possible 5 people ( 2 missing live on the same address and have same second name but different first name).
ASKER
Hi,
Just to let you know that I have sorted it :-) The import from Excel was not alphabetically sorting all people under same names for some reason, so just ORDER BY in combo box row source has sorted it out...
Thank you for all the effort... :-)
Just to let you know that I have sorted it :-) The import from Excel was not alphabetically sorting all people under same names for some reason, so just ORDER BY in combo box row source has sorted it out...
Thank you for all the effort... :-)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It is not clear to me at least, exactly what you're doing or how you've designed it. Have you done a union query to run your search against, or have you actually built a new table out of four others?
Does your search field look at a single field or are you searching entire records for a keyword?