nezbo Posted June 3, 2009 Share Posted June 3, 2009 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 Link to comment https://forums.phpfreaks.com/topic/160765-ms-access-sql-minus-7-days-14-days-21-days-etc/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.