I've been out of the Access loop for a while, and have a quick question.
The data I have is in the following format:
ID Date Total
1234 01/01/1985 524.98
1234 01/01/1986 564.12
1234 01/01/1987 112.25
2346 01/01/1985 475.56
8476 01/01/1985 789.52
8476 01/01/1986 445.55
8476 01/01/1987 123.45
2946 01/01/1985 123.85
1234 01/01/1988 987.65
9927 01/01/1985 127.54
9927 01/01/1986 445.85
I want to run a query, or set up a new table, that translates the data into this format:
ID 01/01/1985 01/01/1986 01/01/1987 01/01/1988 ....
1234 524.98 564.12 112.25 987.65 ....
2346 ...
8476 ...
2946 ...
9927 ...
Any suggestions?
The data I have is in the following format:
ID Date Total
1234 01/01/1985 524.98
1234 01/01/1986 564.12
1234 01/01/1987 112.25
2346 01/01/1985 475.56
8476 01/01/1985 789.52
8476 01/01/1986 445.55
8476 01/01/1987 123.45
2946 01/01/1985 123.85
1234 01/01/1988 987.65
9927 01/01/1985 127.54
9927 01/01/1986 445.85
I want to run a query, or set up a new table, that translates the data into this format:
ID 01/01/1985 01/01/1986 01/01/1987 01/01/1988 ....
1234 524.98 564.12 112.25 987.65 ....
2346 ...
8476 ...
2946 ...
9927 ...
Any suggestions?