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

Multiple queries in a report

P: n/a
Hi, hopefully someone can help me.

I have a report which takes data from seperate queries.

All the queries take a common parameter called 'LoginCode'.

I want to only enter the value once and then for all the queries to use
this value, rather than having to enter it for each query.

What's the easiest way of doing this?
Any help will be much appreciated!

Aug 23 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
probably the easiest way would be to create a form with a control where the
user can enter the value. in each query, set the criteria to refer to the
form control, as

Forms!FormName!ControlName

substituting the correct names of the form and the control, of course. you
can add a command button to the form, to open the report.

hth
<go*************@gmail.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
Hi, hopefully someone can help me.

I have a report which takes data from seperate queries.

All the queries take a common parameter called 'LoginCode'.

I want to only enter the value once and then for all the queries to use
this value, rather than having to enter it for each query.

What's the easiest way of doing this?
Any help will be much appreciated!

Aug 23 '06 #2

P: n/a
Use a form to enter the parameter and run the queries and report while the
form is open. Place the forms field name where you want it in each query in
the form of:
[Forms]![your_forms_name]![your_fields_name]

go*************@gmail.com wrote:
>Hi, hopefully someone can help me.

I have a report which takes data from seperate queries.

All the queries take a common parameter called 'LoginCode'.

I want to only enter the value once and then for all the queries to use
this value, rather than having to enter it for each query.

What's the easiest way of doing this?

Any help will be much appreciated!
--
Message posted via http://www.accessmonster.com

Aug 23 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.