Passing Parameters

[eebabe]

Hello:

I am trying to create a report that uses two queries and both queries uses parameters. q_HRI and q_HRI_Refs both is prompting for start and end date. How can I pass the start and end date from q_HRI to q_HRI_Refs.

The reason for using two queries are the data from each queries are different but in one report I need calculation fields from both queries.

Perhaps there's a better way of doing this rather than joining the two queries.

Thanks.

 

[PHV]

Have a look here:
faq701-6763

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[eebabe]

Thanks for the link. Yes both queries have parameter promts and in this case I have to enter 4 parameters. Start and End date for both queries. I'm trying to limit entering start and end date to just twice. It's more of passing the parameter from 1st query to second query.

 

[dhookom]

IMO, don't ever use parameter prompts in queries. Always reference controls on forms.

Duane
Hook'D on Access
MS Access MVP

 

[randy700]

Perhaps there's a better way of doing this rather than joining the two queries.

There is. See the link provided by PHV.


Randy