Yearly Planner

[ir26121973]

Hi,

Wonder is someone can help please.

I have a table containing data on specific e-forms that I perform certain tests on to make sure they work when down loaded by users.

There are many e-forms with many different tests but for ease of explanation I will use only a few.

The columns are labelled as below with the name of the form in the first column and then the dates under the relevant tests as can be seen in my example. These tests can be carried out on any day throughout the financial year i.e Apr-Mar.

e - Form Test 1 Test 2

Form 1 01/04/06 20/09/06
Form 2 18/10/06 05/12/06

What I would like, if possible is to show this data in a report with a 12 month timeline going across the top and then the forms down the left hand side and the test dates plotted under the relevant timeline date against them.

I'm not sure whether Access is the correct application to do this in but I feel it may be even more difficult in Excel.

Any suggestions or guidance would be greatly received.

Many thanks

Chris

 

[VicRauch]

To put this data into a table, then print from the table, there are two ways to get it into the table. One is an append query which I don't recommend, and two is VBA code. But when you say you are new to Access, I don't know how much you know about VBA code.

 

[ir26121973]

Vic,

In all honesty if someone gives me VBA, then I can follow it to a degree, it just takes a while, but I am keen on learning.

However I don't know enough to start from scratch

Are there generic elements of VBA that I could use?


Regards

Chris