Query problem

[mama16]

How can I create a query that ask for several things, then compare certain statistics about those things.
I've already have a query that ask the user for certain information. It only allows it for one thing

Any ideas?

 

[PHV]

It only allows it for one thing
Really ? What have you tried so far ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mama16]

This is what I've tried so far, a parameter. It ask for a specific state, then beginning date, ending date. My question, is it possible to do it to where it ask for multiple states, then compares them. Ex, The user chooses 5 states and wants to compare those based on their population. Can I do that in access
Any ideas,

 

[lespaul]

yes but you will have to create your own form to allow the users to have multiple choices and then you will have to build your SQL dynamically depending on the choices the user makes.

Leslie

 

[PHV]

Provided you play with a not to old version of access and you enter the choosed states separated with comma, you may try something like this:
WHERE ....
And InStr("," & [Enter wanted states list] & ",", "," & [yourTable].[state field] & ",") > 0 And ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mama16]

I already have a form with all the statistic for the states. I want the user to be able to do it when running a report. What do you mean by having to create another form?

Thanks

 

[mama16]

I'm using Access 2000