I tried searching for this in the forum but couldn't find anything that was similar to what I was looking to do.
I work in a Healthcare environment and need to comply some statistics based on Service Date Field in my table.
Basically if a patient comes in and is seen on 1/3/12 and again on 1/18/12, the weekending date for each should be 1/7/12 and 1/21/12 respectivly.
How do I get Access to figure this out? Please keep this as easy as possible, I am not good with SQL, I use all the basic stuff in access at this point. SQL confuses me usually, specially writing from scratch.