Parameter values don't appear at top of report

  • Thread starter Thread starter Joan
  • Start date Start date
J

Joan

Hi,
I have a query that has parameter values, [StartDate] and [EndDate]. This
query (qrySalespersonFinal) is the record source for a report and is made
from several other queries. However I have two (expression) fields in the
query that are:
SDate: [StartDate]
EDate: [EndDate]


The controls in the report header for these parameters have their control
sources set to : SDate and EDate respectively

My problem is that when I run the report these parameter values do not
appear in the report header like I want. Looking at the datasheet for
qrySalespersonFinal I see that the first salesperson, J, did not have any
sales for the time period specified by the parameters. Therefore, SDate and
EDate are blank for salesperson, J. This is a summary report and I need the
report to show all of the salespersons, whether or not they had any sales
for the specified time period. How do I get the report to show the
parameters in the report heading when not all of the salespersons have
sales? I'd like to tell my report to look at a line of the query where a
field such as SalesPrice (or Pets) is not blank. How do I get it to do
this?

Joan
 
Hi,

Kindly disregard my prior post. I figured it out. I just put the
parameter name itself as the control source. [StartDate] instead of SDate
and [EndDate] instead of EDate.

Joan
 
Back
Top