Report from to dates

K

KAnoe

I have a report that the user does a between date lookup to run the report.
I feed the report with a from the field [enl Date] with the code of

Between [Enter Start Date] And [Enter End Date]

It works great but I need to have a label on the report that will give the
from to dates. As it is now as the user can’t see what dates were run.

Keith
 
A

Allen Browne

You can refer to these parameters in our report.
Use a text box with Control Source of:
=[Enter Start Date] & " to " & [Enter End Date]
 
O

Ofer

I'm not sure, but you can also create the SQL to return the paramaters

Select Field1, Field2, [Enter Start Date] as StartDate , [Enter End Date] as
EndDate
From TableName
Where FieldName Between [Enter Start Date] And [Enter End Date]

That way you can refer to StartDate and EndDate any where in the report,
just as any other field in the table.
 
K

KAnoe

Thanks Allen,

I make it harder that it is.

Keith

Allen Browne said:
You can refer to these parameters in our report.
Use a text box with Control Source of:
=[Enter Start Date] & " to " & [Enter End Date]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

KAnoe said:
I have a report that the user does a between date lookup to run the report.
I feed the report with a from the field [enl Date] with the code of

Between [Enter Start Date] And [Enter End Date]

It works great but I need to have a label on the report that will give the
from to dates. As it is now as the user can't see what dates were run.

Keith
Click to expand...
Click to expand...
 
Top