HELP! Using Multiple Queries

[pcerio]

Hello All,

Is it possible to have two different queries using parameters on the
same report?

Thanks.

Trish

[jnikle]

Trish-

You're question's a little vague, but if you want the results of two
queries in one report, just make reports based on each query and insert
them into another blank report as subreports. If they're using the
same criteria, it's easiest just have the user enter the criteria into
a form and run the report that way. Otherwise, you can have the query
itself prompt for what it needs by doing something like [Enter date:].

If you're talking about combining the results of the two queries or
something, that's a little more situation-specific, and you'll have to
provide more detail.

Hope this helps.

-Josh

[jnikle]

Trish-

You're question's a little vague, but if you want the results of two
queries in one report, just make reports based on each query and insert
them into another blank report as subreports. If they're using the
same criteria, it's easiest just have the user enter the criteria into
a form and run the report that way. Otherwise, you can have the query
itself prompt for what it needs by doing something like [Enter date:].

If you're talking about combining the results of the two queries or
something, that's a little more situation-specific, and you'll have to
provide more detail.

Hope this helps.

-Josh

[Keith]

pc****@romehospital.org wrote:

Hello All,

Is it possible to have two different queries using parameters on the
same report?

Thanks.

Trish

Yes. You would then set the report's record source using code in the
report's "on open" event, something like:

If SomeCondition = True Then
Me.RecordSource = "qryQuery1"
Else
Me.RecordSource = "qryQuery2"
End If

HTH - Keith.
www.keithwilby.com

[Trish]

Hello Josh,

I want to create two different queries, each with their own parameters,
to compile on a report.

Show table data for only 1 month:
Query 1= Between [Start Date] and [Ending Date]

and on the same report...

Show table data year-to-date
Query 2= Between [Start Date] and [Ending Date]

Is this even possible??? Thanks again!

Trish

PS...I don't have any "true" programming experience