fboehlandt
Registered User.
- Local time
- , 01:17
- Joined
- Sep 5, 2008
- Messages
- 90
Hi everyone,
I have a table in my access database that looks as follows:
Fname Fcode Date1 Date2 Date3 Date4 ...... DateN
FundA 10001 30000 20000 12000 14000 ...... xxxxx
FundB 10002 40000 50000 60000 70000 ...... xxxxx
FundC 10003 99999 88888 77777 66666 ...... xxxxx
.......
FundXYZ
The table contains the name of an investment fund and the code of the fund as primary key. In addition, the table contains the fund performance for (200) different dates sorted into columns. I would like to use a query to change the table as follows:
FundA 10001 Date1 30000
FundA 10001 Date2 20000
........ ........ ........ ........
FundA 10001 DateN xxxxx
FundB 10001 Date1 40000
FundB 10001 Date2 50000
........ ........ ........ ........
FundB 10001 DateN xxxxx
etc.
Can this be done? Any help is appreciated
thanx
I have a table in my access database that looks as follows:
Fname Fcode Date1 Date2 Date3 Date4 ...... DateN
FundA 10001 30000 20000 12000 14000 ...... xxxxx
FundB 10002 40000 50000 60000 70000 ...... xxxxx
FundC 10003 99999 88888 77777 66666 ...... xxxxx
.......
FundXYZ
The table contains the name of an investment fund and the code of the fund as primary key. In addition, the table contains the fund performance for (200) different dates sorted into columns. I would like to use a query to change the table as follows:
FundA 10001 Date1 30000
FundA 10001 Date2 20000
........ ........ ........ ........
FundA 10001 DateN xxxxx
FundB 10001 Date1 40000
FundB 10001 Date2 50000
........ ........ ........ ........
FundB 10001 DateN xxxxx
etc.
Can this be done? Any help is appreciated
thanx