Print Date Range

[AN60]

I am using two text boxes on a form to set start & end dates for a report. I wish to print the date range on the report. Any hints?

 

[Kraj]

As is you want the dates themselves to print out on the report or you want records in the date range to print?

I'll assume records in the date range because that the more complicated of the two. In your query that the report runs off of, your Date criteria should be ' Between #[Forms]![MyForm]![StartDate]# and #[Forms]![MyForm]![EndDate] ' The syntax can be tricky and I don't guarantee I did everythign right, but the Between function is what you want..you can use the code builder to get the references to your date input fields correct.

 

[Graham T]

AN60

This should be what you are after -

How to Print Parameters onto your report

HTH

Graham

 

[AN60]

Thank you for your replies. I think Graham T has what I need although I can't get it working just yet.

I am using the following in my query because I use a form to enter the "From" and "To" dates;

Between [Forms]![sale goods by date form]![txtFrom] And [Forms]![sale goods by date form]![txtTo]

In this caes entering the parameter complicates the issue a bit. Any ideas?

 

[Rich]

In what respect does it complicate?

 

[AN60]

When I use, [Forms]![sale goods by date form]![txtFrom] as the parameter the report prints #Name?

 

[Kraj]

Is the form still open when you print the report?

 

[AN60]

Yes the form is open when the report is run.

 

[Rich]

which part of the report prints name?

 

[AN60]

"#Name?# is printed in the unbound text box that I created which is supposed to show my selected date. I guess I am doing something wrong when I type the parameter name. I am selecting the Start and End dates using a form.

 

[Rich]

= "From" &" "& [Forms]![sale goods by date form]![txtFrom]&" "&"through to" &" "& [Forms]![sale goods by date form]![txtTo]


as the control source of the textbox, check the names are correct

 

[R6Flyer]

= "From" &" "& [Forms]![sale goods by date form]![txtFrom]&" "&"through to" &" "& [Forms]![sale goods by date form]![txtTo]


as the control source of the textbox, check the names are correct

AN60,

Also make sure that you haven't given the unbound text box the same name as one of your fields. If you have, simply rename it and the problem should be solved.

 

[AN60]

Rich & Graham T
Thank you both, your help did the trick.

To others who posted, thank you also. I appreciate your contributions.

 

[Oldsoftboss]

Maybe this thread will help
http://www.access-programmers.co.uk/forums/showthread.php?t=60030&highlight=date