Unanswered: Calculating record dated for a friday in the present week
Little silly this - I have used a simple seach screen in the past to seach for people leaving a training course on a friday of the present week.
course are rolling so not everyone goes. Each customer has a leave date allocated on induction in a table named [exptermdate]
I need to automate the process so that I call up maybe a query with a report attached that will list only those in the present weeks leaving group. I can set a print routine for certificates etc to it and get it all do - no issues there - but the leave day issue its got me stuck a little
I looked at using the date features in access but I either dont get the friday (day 6) OR I get every friday. I looked through past posts but nothing close there