Recent content by Fishermanc86

Thank for all your help CJ. I will give this a go.

A working week for us is Monday to Sunday, so the 31/12 would be the first week of January the other weeks you listed would be in December. So I would want WC 31/12, 7/1, 14/1, 21/1 & 28/1 as January Then WC 4/2, 11/2, 18/2 & 25/2 as Febuary and so on.

That is the exact problem, I have tried the Month(date) and it will not pull in the data from wc 31/12.

Hi, I have data sent to me that is in week commencing dates which i append to a table. I need to append this detail to another table where the data is grouped into months. For example the data is for weeks 31/12/2012, 07/01/2013, 14/01/2013, 21/01/2013, 28/01/2013 etc. Is there a formula to...

I live in England. I have been using Excel for many years to do reporting and have used Access infrequently. My new role requires me to use access more alongside Business objects. I have the Access basics sorted, but some of the more advanced stuff I will need a little help with. My hobbies...