To make it easier, it already assigns a "week ending" date, so every record has a Saturday date. I just want to have the returns limited to the items with the date from "last Saturday"
I will run this query any day from monday to Friday of "This Week", but I always want it to ONLY show the results from last week.
Does that make sense? thanks.