SELECT DateAdd("d",Date(),7*([Ones_1].[Digit]*10+[Ones].[Digit])) AS A
FROM Ones, Ones AS Ones_1
ORDER BY DateAdd("d",Date(),7*([Ones_1].[Digit]*10+[Ones].[Digit]));
Table Ones holds digits 0 to 9 - 10 rows. Use Where clause to limit range.
Clive
"Not Me" <No****@faker.fake.fa.kee> wrote in message
news:c6**********@ucsnew1.ncl.ac.uk...
Hi,
Not sure if this would be possible without using vba or similar
programming, but can I use sql to create a column of dates in a regular sequence (such
as weekly, monthly etc.)
I would like the results to be e.g.
date
01/01/04
08/01/04
15/01/04
22/01/04
29/01/04
Many thanks,
Chris