Multiple queries in a report

[gordon.ferguson]

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!

[tina]

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!

[jahoobob via AccessMonster.com]

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