Report in a certain time frame

[Thora]

Report in a certain time frame - from date to date.

If my query began January 2000 till May 2003,
how do print a report from June 2001 - December 2002.
This is just an example of what I am trying to accomplish.

If this makes sense to anyone...I will be greatfull for the help.

Thanks,
Thora

 

[randysmid]

Hi,
I created a form where the user can select two different dates, a "From" date and a "To" date. I then use these dates as criteria for a query. The report uses the query as its recordsource. I wrote an FAQ on how to send criteria to a query. Take a look at this FAQ: faq703-2696

Your date field inside the query will have a criteria similar to this:
Between "#" & [Forms]![frmDateRangeRept]![txtFrom] & "# and #" [Forms]![frmDateRangeRept]![txtTo] & "#"

FYI: The pound signs are REQUIRED to be placed around text box fields that are acting as dates.

HTH,
Randy Smith
California Teachers Association