basing report control value on parameter from underlying query

  • Thread starter Thread starter BJM
  • Start date Start date
B

BJM

I have a report that is based on a parameter query. The
parameter asks for an opening week number and then a
closing week number.

Ideally, I would like to have a control on the report
capture the opening week number and convert it to a date.

Our week numbers begin September 1st, the start of a new
school year.

Thanks,
BJM
 
I think the following could help.
You could determine the weeknumber using a query by
entering Now() and set the format to ww.
For instance for today 11/2/03 this would return 45
In the same query you can have #1/1/03# with the ww format
this would return 36
by the same token Now() -#9/1/03# with a format of ww
would return 9, indicating you are now in the 9th week of
the school year.
Maybe the above wil help you to get to the calculations as
you were describing.
Fons
 
Does this mean there is no way to capture to parameter
value from the underlying query?

I think that would be more efficient if it were possible.

BJM
 
BJM said:
I have a report that is based on a parameter query. The
parameter asks for an opening week number and then a
closing week number.

Ideally, I would like to have a control on the report
capture the opening week number and convert it to a date.

Our week numbers begin September 1st, the start of a new
school year.
Click to expand...

Have you tried using a text box (in the report header?) with
its control source set to the **exact** same text as the
parameter name or prompt?

For example, if your parameter is a prompt for the week
number as in:

Select . . .
From . . .
Where tbl.weeknum > [Starting Week Number]

then you can use a text box bound to:
[Starting Week Number]
 
Back
Top