Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

passing parameters in a report

Status
Not open for further replies.

amandabf

Technical User
Aug 30, 2001
11
US
I have a report with many subreports and each query is dependent upon the date range. How do I pass the date parameters between queries. I tried entering the parameters in a form and linking them to my queries. This works for my plain select queries, but not my crosstab queries (which are very important). Please help me.
 
Can you store these dates in a table & then just reference them from there for as long as you need them??? J. Jones
jjones@cybrtyme.com
 
Amandabf:

What did it do in your crosstab queries?? That technique does work in them, I've done so myself...

Joe Miller
joe.miller@flotech.net
 
I figured it out. I wasn't setting my column headings property. Oops! Thanks for your help, everyone!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top