By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,658 Members | 1,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,658 IT Pros & Developers. It's quick & easy.

"Interactive" query

P: n/a
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
Aug 10 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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: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

Aug 10 '06 #2

P: n/a
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: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


Aug 10 '06 #3

P: n/a
This is magic. Now how do I capture that in a report header? Should look
something like: North Area, Round [round number]?
Aug 11 '06 #4

P: n/a
This is magic. Now how do I capture that in a report header? Should look
something like: North Area, Round [round number]?
Aug 11 '06 #5

P: n/a
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: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]?

Aug 11 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.