"Interactive" query

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

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" <x@x.xschreef in bericht news:4k1nipFa2dnvU1@individual.net...

Quote:

>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

>

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" <x@x.xwrote in message news:4k1nipFa2dnvU1@individual.net...

Quote:

>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
>
>

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

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

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" <x@x.xschreef in bericht news:4k2kpgFa9t4oU2@individual.net...

Quote:

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

>

"Interactive" query

re: "Interactive" query

re: "Interactive" query

re: "Interactive" query

re: "Interactive" query

re: "Interactive" query

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about