Hello,
I have created a form to gather information about the staff’s IT knowledge level into access database 2003. Say for example
1. Microsoft Word – with dropdown menu of “Basic” “Intermediate” or “Advanced”
2. Microsoft Excel – with dropdown menu of “Basic” “Intermediate” or “Advanced”
3. Microsoft Access – with dropdown menu of “Basic” “Intermediate” or “Advanced”
I have successfully created a query which can output the profile of a staff with say “Intermediate” knowledge level in “Microsoft Word” by chosing from a drop down menu with “Basic” “Intermediate” or “Advanced” in the query form.
But I want to create a new view which would output the profile of any staff irrespective of knowledge level in a particular knowledge area. Say for example, if in the query form, I created a checkbox and checked on a “Microsoft Word” checkbox, it should output all staff profile with either “Basic” “Intermediate” or “Advanced” level of “Microsoft Word”. How to I do this? (Since data type is "optional_Boolean" for checkbox field and "simpleType" for dropdown field and I need two views for running both the queries).
Thanks for your help
Aputta