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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.