Timetable "hobbit2612" <u27332[ at ]uwe> 30.09.2006 12:18:33 Hi, Wonder if someone can help me please. I am relatively new to access, and what I do know is self taught, so I sometimes need a little more guiding than most. I have a form containing data on tests that are carried out e-forms that my department use, so the form that I have set up looks like this: E- Form Description Test 1 Test 2 Form 1 01/05/06 28/10/06 Form 2 15/06/06 12/12/06 Form 3 01/01/07 02/02/07 So three headings showing the form description and then the dates that the tests were or will be carried out. What I would like to do is to put this data in a report to show a timeline across the top of the page running weekly from April to March with the ability to change the years as and when I need to. What I would then like to show is the form descriptions down the left hand side and then the dates of the tests plotted under the relevant dates on the timeline, but obviosuly on the relevant forms row. I'm assuming that the date shown on the report will be a text box, so what I would like if possible, is to show the date of the actual test in the text box and for each individual test to have it's own colour, so these can be easily interpretated on the report. I have tried so many things and ideas to get this to work and had some great advice from other forums, but just can't seem to get it right, I was hoping a fresh new forum with fresh new ideas. Many thanks Chris