Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343

    Unanswered: Calculating record dated for a friday in the present week

    HI Guys

    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

    any ideas?

  2. #2
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    Oh for goodness sake

    Sorry Guys

    To many cans of good beer me thinks!!!
    Its :-
    Date() - WeekDay(Date()) + 6

    I do believe.

    Sorry again for being a prat
    Gareth

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •