Hi all. I'm very new at sql so first I hope I'm posting in the right place. I'm using ms access until I hone my skills so here goes:
Is this possible?
I'm grappling with the DateAdd and DateDiff functions but I'm not a good enough programmer or I don't think programmatically enough to work out how to do this.
What I have now is:
SELECT tblRotaion.RotationWeek, tblRotaion.Member
All I want to return however is the most recent Sunday not all Sundays in the past. Then next week, 4/1/07 will be a new person.
Thanks in advance.