Date Parameter to be displayed in report

[smarty84handsome]

I am using date parameter to generate report. Is it possible to display date parameter in report ? For e.g. This report is "from date: to to date:"

[amrut]

How do you pass the date parameter to generate report ?

[June7]

Use a textbox on form to enter the date value, then options:

1. pass the date parameter to report with OpenArgs argument of OpenReport
DoCmd.OpenReport "report name", , , , , , Me.textboxname

2. in ControlSource of textbox on report, reference the form textbox
=Forms!formname!textboxname

[smarty84handsome]

I am passing parameter it through queries

[smarty84handsome]

Use a textbox on form to enter the date value, then options:

1. pass the date parameter to report with OpenArgs argument of OpenReport
DoCmd.OpenReport "report name", , , , , , Me.textboxname

2. in ControlSource of textbox on report, reference the form textbox
=Forms!formname!textboxname

The problem with text box is that i will have two data parameters one coming from queries and another coming from text box.
Is there any other way with which the data parameters which i am using from queries will also show up on report ?

[June7]

What do you mean by 'coming from query' - a popup input parameter? I never use popup inputs in query. Can't validate input and if it is in the criteria row, it is not available for further reference. Actually, I don't use dynamic parameters in queries at all. I use forms to input parameters and then pass the parameters to report with WHERE CONDITION, like:

DoCmd.OpenReport "report name", , , "ID=" & Me.ID, , Me.datetextbox

[smarty84handsome]

What do you mean by 'coming from query' - a popup input parameter? I never use popup inputs in query. Can't validate input and if it is in the criteria row, it is not available for further reference. Actually, I don't use dynamic parameters in queries at all. I use forms to input parameters and then pass the parameters to report with WHERE CONDITION, like:

DoCmd.OpenReport "report name", , , "ID=" & Me.ID, , Me.datetextbox

Well in my case the project that i am working on requires to pull up report using date range and same date range need to be showed on report. I am using form just for entry purposes. What are my options ?

[June7]

I think the options are already described. What specifically do you not understand?

Review:

http://www.allenbrowne.com/ser-62code.html

http://www.datapigtechnologies.com/f...mtoreport.html

[smarty84handsome]

I think the options are already described. What specifically do you not understand?

Review:

http://www.allenbrowne.com/ser-62code.html

http://www.datapigtechnologies.com/f...mtoreport.html

I will post the outcome let me follow the video....it seem very interesting and helpful

[smarty84handsome]

I will post the outcome let me follow the video....it seem very interesting and helpful

I was able to solve the issue and i did it the way you recommended me thanx for the great help.

[phivosz]

My preferred way is to write the value to a table and then read it with the "on open" event of the report.