Need to run a report every monday from last weeks table data

[fuxxociety]

First off, I'm an access newbie so I'm not too familliar with modules
and VBA/sql code..

http://coldfire.myftp.org/~fuxxy/flaredowntime.mdb

I have a rather simple database with one table(tbl_Downtime) listing
facility delays:

"ID" "StartDate" "StartTime" "EndDate" "EndTime" "Notes"
1 7/30/2006 20:25:00 7/31/2006 0:15:00 "fuel boats"
2 7/31/2006 6:30:00 7/31/2006 12:00:00 "pilot light problem"
5 8/3/2006 8:00:00 8/3/2006 8:30:00 "Flare Maintenance"
6 8/4/2006 22:45:00 8/4/2006 23:45:00 "Pilot blew out. Notified Jerry."

I want to have a combobox on a form that will allow me to select
criteria from that table(tbl_Downtime) based on what week it happened:

Jul 31 - Aug 6
Aug 7 - Aug 13
etc

On top of that, our weeks up here are categorized from Monday to
Sunday.. I eventually want that too, but the important part is being
able to print a report with last week's entries

 

[Jeff C]

Build a text box on a form for the start date and another for the end date,
label as such.

reference these in the query that is the record source for your report in
the criteria for one of the date fields you have.

between forms[Myform]![startdate] and forms[Myform]![end date]