Display a specified date range on a report

[Spicealdous]

I have set up a basic query in which I have a date field. In the criteria for this field I have stated "between [Enter start date] and [Enter end date]" in order to allow me to view any date range.

Could anybody help me as I wish to display this range on a report.

 

[KicksMyAccess]

When setting up the report, base the report on the query. When you run the report the query will prompt you to [Enter start date] and [Enter end date] before the report displays to the screen.

 

[danvlas]

Create a text box on the report and set its control source to:

="Between " & [Enter start date] & " And " & [Enter end date]

I know, I know...it's easy LOL


Daniel Vlas
Systems Consultant

 

[WildHare]

... and make sure you SPELL the parameter guys exactly the same as they appear on the query - otherwise the report will prompt you again for the same stuff....

Jim Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[linda55]

We all have to start somewhere.
Create a textbox in the heading of your report with a control source similar to this:
="Checks written between" & [Enter Start Date] & " and" & [Enter End Date]
This has worked for me.

 

[teebird]

Hi

I have used your code. Can you please tell me how to format the date to eg 1 January 2003.

Thanks in advance.

tee

 

[danvlas]

Format(YourDate, "dd mmmm, yyyy&quot


Daniel Vlas
Systems Consultant