from to date on top

[jebi_babu]

Hi,
I made a report from a query. which is based the first field as date, there my query starts as between start date and end date. Now what i want is in my report i have to get the date on the top of the report near to the title. I am very new in access. Hope somebody will help
thanks and regards
by
nowfal

 

[MStCyr]

Hi,
I made a report from a query. which is based the first field as date, there my query starts as between start date and end date. Now what i want is in my report i have to get the date on the top of the report near to the title. I am very new in access. Hope somebody will help
thanks and regards
by
nowfal

You will have to create a form where you enter the Start and End dates in two text boxes, let's call this form frm_EnterDates. This form will have two text boxes, let's call them txtStart and txtEnd.

On your report, you can now refer to form frm_EnterDates and txtStart, txtEnd in the following fashion

Place a textbox on your report with the following expression:

=forms!frm_EnterDates!txtStart & " " & forms!frm_EnterDates!txtEnd