'Microsoft Access Expert' Technology  

Godfrey Peter (193.57.110.171) -

whoever is looking for a microsoft access expert just email me. i have extensive skill in developing databases, queries,reports,and vba

No trackbacks.

Reply #1 Chad Hullender (70.244.183.242) - Sun May 4 17:35:43 2008

conditional query. I am completing a utility for a survey that has 50 questions. There are some demographic type questions at the top of the survey, (seniority, age, gender, position, etc) and those are naturally captured in the database. I have created a form using I think an option list for each demographic category. Here is the question. What if I want to do a query where for instance I don't care what the gender is? How can I do a conditional wildcard to "ignore" that field on the query for that specific demographic category? does that make sense?

Or better yet...let's say I want to see how all managers, that are female completed the survey. But I don't care what their seniority is. The value for position would be "1" for managers, and for gender "2". The value I want to pass for company seniority is "like "*"" so that it doesn't filter on that category.

If I was building this in .asp I would just check the value of each demographic and build a select statement that was comprised of variables after checking each demographic.

Name:           
E-Mail:         

Optional (please add link to our directory first)
Web Link:       

Link Title:     

Message:

Note: once you register your email address with Expat and Travel it is used across our whole network of forums and blogs. You can create seperate profiles for each forum or blog, but use the same login.