Access query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I hope someone can point me in the right direction - what I am trying to do
is write the ctiteria in a query that will select the last friday in a month
- preferably if it can relate to the current date ie , any ideas would be
appreciated.

I am using Access 97
 
Between
DateAdd("d",1-DatePart("w",DateSerial(Year(Date()),Month(Date()),0),6),DateS
erial(Year(Date()),Month(Date()),0)) and
DateAdd("d",1-DatePart("w",DateSerial(Year(Date()),Month(Date())+1,0),6),Dat
eSerial(Year(Date()),Month(Date())+1,0))
 
Thanks Rick will try this one- sorry for posting in 2 places - first time on
this site - ii will learn
 
Back
Top