Query question

Last post 04-30-2008 12:20 PM by Clay Fox. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

04-30-2008 10:54 AM

aputta
Joined on 04-11-2008
Posts 2

Query question

Reply Contact

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 “None” “Basic” “Intermediate” or “Advanced”2. Microsoft Excel – with dropdown menu of “None” “Basic” “Intermediate” or “Advanced”3. Microsoft Access – with dropdown menu of “None” “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 choosing from a drop down menu with “None” “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 another drop down list item named “Any”, it should output every staff profile with either “Basic” “Intermediate” or “Advanced” level of “Microsoft Word”. How to I do this (as to exclude the “None” which is set as default)? Also how do I exclude fields from query, say for example I want to run query to find all the staff with “any” knowledge level in “Microsoft Word” and “Microsoft Access” but not interested in finding about “Microsoft Excel” knowledge level, which is set with the default “None”? Thanks for your helpAputta

04-30-2008 12:20 PM In reply to

Clay Fox
Joined on 06-27-2006
USA
Posts 1,935

Re: Query question

Mark as Not Answer Mark as Answer ...

Reply Contact

With database type forms you do not have much flexibility since the schema is automatically created.

I would probably make a view in Access of the information with software and profiicancy being the key index values.

Then create a seperate from based on this view and design it the way you want.

So a form for entry and collection then another form for analysis and lookup.

Clay Fox / Microsoft InfoPath MVP

Page 1 of 1 (2 items)