Parameter Query

[majoh60]

Is it possible to have a parameter query that uses multiple values?



Example: I have a query where the Quarter Field can have values of 1,2,3 or 4. I want to be able to run the query using a combination of any of the quarters (eg. 1 and 2, 1 only, or 1,2,3 and 4) to give me my totals. Is there a way to do this?

I am very new to Access and I am learning as I go.

[June7]

This requires VBA code to construct a criteria string.

Here is an example that uses listbox http://allenbrowne.com/ser-50.html

Another approach would be to have 4 checkboxes and construct the string with values that have corresponding checkbox checked.

Do you also need year in the criteria?

[majoh60]

This is way above my level of expertise. I might have to come up with another angle but thanks.

This requires VBA code to construct a criteria string.

Here is an example that uses listbox http://allenbrowne.com/ser-50.html

Another approach would be to have 4 checkboxes and construct the string with values that have corresponding checkbox checked.

Do you also need year in the criteria?

[alansidman]

You might give this idea a try. So long as the quarters you are looking to return are consecutive, ie. 1-2, 1-3, 1-4, 2-4, then the between function may work.

Look here: http://www.w3schools.com/sql/sql_between.asp

[Ron99]

I believe this is what you want.

http://www.datapigtechnologies.com/f...ameterbox.html