I am using Access 2002 (XP) and am not a complete newbie, yet I feel like I'm always learning new things when it comes to Access..
I've got a simple table with these 4 fields:
- ID (Autonumber)
- Year (ie: 1999, 2000, etc)
- Quarter (can ONLY be 1,2,3 or 4)
- Return (a decimal, ie: 0.0131, which gets converted to a percentage)
I'd like to setup my report so that it will look similar to this:<code>
1 2 3 4
------------------------------------------------------
1998 | 3.12% 5.91% 6.42% 1.27%
1999 | 4.32% 1.35% 1.24% 1.45%
2000 | 6.25% 5.54% 6.45% 4.45%
2001 | 1.23% 1.53% 4.67% 7.23%
</code>
...Understand? Please help! Thanks!
-NT
I've got a simple table with these 4 fields:
- ID (Autonumber)
- Year (ie: 1999, 2000, etc)
- Quarter (can ONLY be 1,2,3 or 4)
- Return (a decimal, ie: 0.0131, which gets converted to a percentage)
I'd like to setup my report so that it will look similar to this:<code>
1 2 3 4
------------------------------------------------------
1998 | 3.12% 5.91% 6.42% 1.27%
1999 | 4.32% 1.35% 1.24% 1.45%
2000 | 6.25% 5.54% 6.45% 4.45%
2001 | 1.23% 1.53% 4.67% 7.23%
</code>
...Understand? Please help! Thanks!
-NT