[mso] Re: Access 2002: Main/Sub Reports Parameters

Thanks, James.  Right now I'm just launching from the report menu, one
report contains the five sub reports.  They are not related to each other
in the report, though they all ultimately pull data from the same table.
I'm not quite with you yet on the form, how would I set this up? Thanks.


                                                                                
                  
                      James LaBorde                                             
                  
                      <jlaborde@xxxxxxxxx      To: "'mso@xxxxxxxxxxxxx'" 
<mso@xxxxxxxxxxxxx>      
                      >                                                         
                  
                      Sent by:                 cc:                              
                  
                      mso-bounce@freelist                                       
                  
                      s.org                    Subject:  [mso] Re: Access 2002: 
Main/Sub Reports  
                      05/24/2004 03:57 PM         Parameters  :VSMail mx1       
                  
                      Please respond to                                         
                  
                      mso                                                       
            ..... 
                                                                                
                  
                                                                                
                  




Cathy,

How are you launching the report?  The simplest solution would be to create
a small form so that you could input the beginning and ending dates, then
simply click a button and you could refer to the form's fields as your
parameters.

James

-----Original Message-----
From: Cathy.Evans@xxxxxxxxx [mailto:Cathy.Evans@xxxxxxxxx]
Sent: Monday, May 24, 2004 11:24 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access 2002: Main/Sub Reports Parameters


Re-sending below request.  My email had some errors earlier and I haven't
received any mail for several hours, and this is not showing up on my end
as having been successfully sent, so am re-submitting, thanks.
____________________________________________________________________________

I have a main report that contains 5 sub reports, each one reporting
different criteria from the same table.  I can set a parameter in each sub
report query to look at the dates so I can pull the report by Quarter,
however, this would cause 5 question/answer pop ups when the report is run,
one for each sub report embedded in the main one.  I would like to be able
to run the main report and answer the date to/from question once, then have
the data be correct for all 5 sections of the report.  I thought I'd seen
this type of problem here before, however I'm not finding it so am starting
over.  Also, would like the dates I enter in the parameter pop up to show
on the report so Quarter queried will be known.

My report has no data source, the data comes from the queries in each sub
report, 5 total.  All are looking various detailed breakouts of the same
table.  Hope I am asking correctly, please let me know further details
needed.  Thank you, Cathy






-----------------------------------------------------------------------------------------------------
The information transmitted is intended only for the person
or entity to which it is addressed and may contain confidential
and/or privileged material. If you are not the intended recipient 
of this message you are hereby notified that any use, review,
retransmission, dissemination, distribution, reproduction or any
action taken in reliance upon this message is prohibited. If you 
received this in error, please contact the sender and delete the 
material from any computer.  Any views expressed in this message
are those of the individual sender and may not necessarily reflect 
the views of the company.  
-------------------------------------------------------------------------------------------------------

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: