Query criteria attempting to be used:
IIf(Day(Date())<=7,Between Date()-Day(Date())+1 And Date(),Between Date()-Day(Date())+1 And Date()-Weekday(Date(),2))
I have used both Between statements individually.
This one has been what I have been using by itself to pull from the 1st day of the...