want date parameter to show on rpt

  • Thread starter Thread starter nydia
  • Start date Start date
N

nydia

i have a report that is based on a query. this report
shows the clients that were terminated from a specific
program within a given time span. in the termination date
field (in the query)it prompts the user to enter begining
and end date

between [enter begining date] and [enter end date]

how can i do it so that the dates that are entered into
the prompts will show up on the report.

ex.

clients terminated from 01/01/04-03/31/04

can someone please tell me how to do this
 
add a text box and then put as its source the Parmeter
including the square brackets
In your example
[enter begining date]

HTH
 
i have a report that is based on a query. this report
shows the clients that were terminated from a specific
program within a given time span. in the termination date
field (in the query)it prompts the user to enter begining
and end date

between [enter begining date] and [enter end date]

how can i do it so that the dates that are entered into
the prompts will show up on the report.

ex.

clients terminated from 01/01/04-03/31/04

can someone please tell me how to do this
Click to expand...

Add an unbound control to the report.
Set it's control source to something like:
="Clients terminated from " & [enter begining date] & " to " & [enter
end date]

The text within the brackets MUST be identical to the bracketed prompt
text in the query.
 
Have the query get the date information from unbound
controls on a form. Add a command button to produce the
report. You can reference those dates from the form in the
report by adding a control with a control source of

"between "&[Forms]![form name]![fromdate]&" and "
&[Forms]![form name]![todate]

Jim
 
It works, thanks to all :)
-----Original Message-----
add a text box and then put as its source the Parmeter
including the square brackets
In your example
[enter begining date]

HTH

i have a report that is based on a query. this report
shows the clients that were terminated from a specific
program within a given time span. in the termination date
field (in the query)it prompts the user to enter begining
and end date

between [enter begining date] and [enter end date]

how can i do it so that the dates that are entered into
the prompts will show up on the report.

ex.

clients terminated from 01/01/04-03/31/04

can someone please tell me how to do this
Click to expand...


.
Click to expand...
 
Back
Top