Jump to content

MS Access sql - minus 7 days, 14 days, 21 days, etc...


nezbo

Recommended Posts

Hi all

 

I a creating a query the gets an [entered date] - 7 days then - 14 days then - 21 days etc...

 

i have this

 

FORMAT(Appointments.[18 Week Start Date], "DD-7/MM/YYYY")

FORMAT(Appointments.[18 Week Start Date], "DD-14/MM/YYYY")

FORMAT(Appointments.[18 Week Start Date], "DD-21/MM/YYYY")

 

The problem is that when i get to 14 and 21 the amounts are the same

 

Please help

 

Cheers,

Neil

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.