Using parameters in Report Object ControlSource Expression

A

angelrhi24

Hi! I have been trying different ways of using the input parameter
value in my report object's controlsource expression builder with no
luck. Searched the web for answers and no luck.

My parameter is a date input. Example= 03/01/05

The report includes 5 different task completion dates. Those dates are
updated annually. My query associated with this report selects records
that have at least 1 task completion date that is less than the
parameter date (03/01/05). If all of the 5 tasks completion dates are
03/01/05, the record is not included when the report is run.
Click to expand...

I have records that have ONLY 3 task completion date > 03/01/05 so that
record is included in the report. I want to display "LATE" on all task
completion dates that are less than 03/01/05. I am currently using the
Iif function but somehow, the expression builder does not recognize the
input parameter.

HELP!!!
 
D

Duane Hookom

It doesn't make any difference if the expression builder can see the
parameter or not. You can simply type it in where needed.
 
Top