"Interactive" query

[Julian]

I have a saved query from which I build my weekly customer reports. It
queries a "Region" column which has predefined values: North, South etc.
With this same query I would like to quier one more column called "Round"
which has NON-predefined values. So when I double click on the query a
window should popup asking me what value would I like to enter for the
"Round" column. How do I do that?
Julian

[Arno R]

Go to the field "Round" in the query-view
Put something like [Give me the value for the Round] in he criterion row of the query

Arno R

"Julian" <[e-mail] in bericht news:4k************@individual.net...

>I have a saved query from which I build my weekly customer reports. It
queries a "Region" column which has predefined values: North, South etc.
With this same query I would like to quier one more column called "Round"
which has NON-predefined values. So when I double click on the query a
window should popup asking me what value would I like to enter for the
"Round" column. How do I do that?
Julian

[Rob Woodworth]

hey,

all you need to do for that is go to the design view for the query and
under the criteria for the Round field type in [Round?] and it will prompt
for you to enter the round and then only show results where the round field
equals the round value you entered.

Rob

"Julian" <[e-mail] in message news:4k************@individual.net...

>I have a saved query from which I build my weekly customer reports. It
queries a "Region" column which has predefined values: North, South etc.
With this same query I would like to quier one more column called "Round"
which has NON-predefined values. So when I double click on the query a
window should popup asking me what value would I like to enter for the
"Round" column. How do I do that?
Julian

[Julian]

This is magic. Now how do I capture that in a report header? Should look
something like: North Area, Round [round number]?

[Julian]

This is magic. Now how do I capture that in a report header? Should look
something like: North Area, Round [round number]?

[Arno R]

Create a textbox in the report header
Use the SAME criterion as used in the query as the controlsource like =[Give me the value for the Round]

Or (to get North Area, Round [round number] as you ask)
="North Area, Round [" & [Give me the value for the Round] & "]"

Arno R
Access needs to know
"Julian" <[e-mail] in bericht news:4k************@individual.net...

This is magic. Now how do I capture that in a report header? Should look
something like: North Area, Round [round number]?