wafw1971 (2/6/2013)
thanks for the quick replies, because I am learning I have decided to just populate the first column with a date say 01/01/2010 and then increase this in increments of 1. I have quickly had a look online and I have seen I can do a do wile statement.
Just because you can does not mean that you should.
Your WHILE loop will be an order of magnitude slower than a set-based solution, such as those proposed here.
--EDIT fixed typo.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.