My Situation! (1 Viewer)

I am creating a database that tracks reports that are generated from people in the field...The statistics are tracked on a 28 day cycle, beginning on a Monday and ending on a Sunday. Every week the 28 day period loses the first week and gains a week on the end. I need to develop a way to generate the queries for the reports based on a clock that automatically "calculates" the current 28-day period.

Please post ur apllication with little more detail....

if I get you right then this should work in a query
Between Date()-Weekday(Date(),2) And Date()-Weekday(Date(),2)-27

Peter