ir26121973
Board Regular
- Joined
- Mar 7, 2006
- Messages
- 79
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
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