Query with different data types

aputta — Fri, 11 Apr 2008 19:41:29 GMT

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

Newbie Questions

Query with different data types