tough query question!

[George]

Hi,
some history...
I have a query that lists all the holdings and all the bank accounts from
one particular Bank - there are many different accounts in the one bank.
I then have a Criteria prompt in a query that asks for the account name to
be entered. E.g under account name field [Enter Account name, techo,
onecall,elect 2, :].
When i run my report the criteria prompt comes up asking me to enter the
account name.
My problem is that in my report it has two unmatched reports attached and
all the account names unmatched come up in the report when i only want the
account i entered.
I could of course use this criteria for the two unmatched reports but this
means that i would have to enter the account name 3 times. Is there a way to
have the two unmatched reports source the account name from the 1st prompt in
my query?
Thanks
George

 

[John Vinson]

I could of course use this criteria for the two unmatched reports but this
means that i would have to enter the account name 3 times. Is there a way to
have the two unmatched reports source the account name from the 1st prompt in
my query?

Don't use a prompt - use a Form instead. Create a little unbound Form
with textboxes (or combo boxes, better, so you can select existing
accounts) for any criteria you need. Use a criterion

=[Forms]![NameOfTheForm]![NameOfTheControl]

Put a command button on the form to launch the Report.

John W. Vinson[MVP]

 

[George]

Hi John,
I have created a form which lists all the accounts with Row Source Type:
Value List and Row Source as the list of accounts. I dont get where and what
i put in the criterion where the account name flows through to each query?
George

I could of course use this criteria for the two unmatched reports but this
means that i would have to enter the account name 3 times. Is there a way to
have the two unmatched reports source the account name from the 1st prompt in
my query?

Don't use a prompt - use a Form instead. Create a little unbound Form
with textboxes (or combo boxes, better, so you can select existing
accounts) for any criteria you need. Use a criterion

=[Forms]![NameOfTheForm]![NameOfTheControl]

Put a command button on the form to launch the Report.

John W. Vinson[MVP]

 

[George]

John,
I just had a thought. Is it possible to link the subreports through Child
links so that the account name is a common them in both reports?

Hi John,
I have created a form which lists all the accounts with Row Source Type:
Value List and Row Source as the list of accounts. I dont get where and what
i put in the criterion where the account name flows through to each query?
George

I could of course use this criteria for the two unmatched reports but this
means that i would have to enter the account name 3 times. Is there a way to
have the two unmatched reports source the account name from the 1st prompt in
my query?

Don't use a prompt - use a Form instead. Create a little unbound Form
with textboxes (or combo boxes, better, so you can select existing
accounts) for any criteria you need. Use a criterion

=[Forms]![NameOfTheForm]![NameOfTheControl]

Put a command button on the form to launch the Report.

John W. Vinson[MVP]