Find the weekendings

[lars7]

Hi,
I'm trying to make a table of dates through a make table query but I'm having trouble finding the weekendings. The following produces Sunday to Saturday as the beginning and ending of the week but I would like Monday to Sunday.Could anyone point me in the right direction please.

FldWeekends: [FldDays]-Weekday([FldDays])+7

Thanks in advance.

 

[Remou]

As in:

[tt]FldDays - Weekday(FldDays, vbMonday) + 7; Weekday(FldDays, vbMonday)[/tt]

 

[PHV]

beginning: [FldDays] - Weekday([FldDays],2) + 1

ending: [FldDays] + 8 - Weekday([FldDays],1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lars7]

Thanks for the replies,

Sorry Remou I had a problem with your semi-colon,

PH yours works great.

Cheers.

 

[Remou]

It originally had a Debug.Print in front, to test. I removed the debig.print and forgot the second part . It should have read:

[tt]FldDays - Weekday(FldDays, vbMonday) + 7[/tt]