Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delineate a report by week number

Status
Not open for further replies.

niteraven

Technical User
Oct 26, 2006
92
US
I have a report grouped by week number. It all works fine. I want to have this report only show the current week number and the 3 following weeks. The report is based on a query.
 
Set the record source query to filter for the records. Do you calculate the week number in the record source? Do your weeks run Sunday - Saturday?

Try using a criteria like:
Code:
  Between date() and Date() + 21

Duane
Hook'D on Access
MS Access MVP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top