Query Pulling wrong Date

[kentwoodjean]

Below is the format I am using in a query to pull data for the previous week. The data w/data on the query is for the wrong weeks. For example, on Monday 4/4, I ran my query and it pulled data and showed a weekending date of 4/1. Problem is, this is the data for the weekending 3/25. Consistently, the data for each weekending is not the previous week but 2 weeks earlier. Hope this makes since.

CountClosed Dt: Sum(Nz([CountOfClosed Dt],0))
CountDate1: Sum(Nz([CountOfDate1],0))
Weekend: [Closed Dt]-1-Weekday([Closed Dt])

 

[kentwoodjean]

I think that I have figured this out. While I was on vacation, my backup did not run the query one week and so a date is missing which caused the whole string of dates to mess up. I should be able to fix the missing data. Sorry to have posted.