Hi,
Can someone guide me step-by-step on how to create a form that when i search for a language, it will give me all the employees that speak that language?
But I followed it and tried it. When I type in "English" for one of the languagues, it only brought up like 5 people. I know there's more people than that who speaks English. How come it's like that? Is there another helpful video that you know about that can help me out? Thanks
Without seeing your layout, it is difficult to say. What does your table layout look like? Are all languages listed in one field? Or do you have multiple language fields? If multiple fields, then you probably have a normalization issue.
Suggest you post it on box.net or some similar location and then post the link here on MrExcel. Then many more than just me can look at it and offer help. You want the widest possible exposure.
Alan
First, as I suspected your db is not normalized. You should have only one field for language and not five. You should set up a separate table for the languages, then have a one to many relationship between the employee table and the language table.
Now to the current set up of your query, you have placed your criteria on the same line for each language. This creates a criteria logic of must be English in Language1 field and Language2 field and Language3 field, etc. To make this work with the current set up, you will need to put the criteria on separate lines to create an "OR" effect.
I tried putting the criteria in the "OR" rows, but when I put in "English" for Language 1 and "Spanish" for Language 2, it wouldn't give me the records containing only those records.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
