Create report that looks like an Excel table

[Mmmel]

Hi again! I want to create a report that uses the following fields from my financial database:

Accountname (name of the account - there are three)
Firstday (Jan 1, Feb 1, etc)
Balance (the balance on each of the firstdays)

and outputs something that looks just like it would in Excel, with the account names on the vertical, the firstdays on the horizontal on the top, and the corresponding balances in the area in the middle:

                Jan 1   |   Feb 1   |  Mar 1   |
____________________________________________
Chequing       $550.00  |  $750.00  |  $900.00 |
Savings        $650.00  |  $250.00  |  $800.00 |

(I can't get this to preview like I typed it in - it's supposed to look like a table!)

and so on. Am I making any sense? I thought I would do this using a pivot table, but each time I try, Access 2007 hangs. Something obviously wrong there. Is there any other way I can do it? Thanks!

[Narender Sagar]

You can create query instead, if you want excel like table, and then make datasheet form. Set its enable property to 'No' that way users will not be able to edit data.
HTH

[NeoPa]

I would suspect that a Pivot Table would be exactly how to get this to work.

I'm no good with those, but I suggest you post what you tried, and exactly what went wrong, and see if one of our other experts (many of whom are very good with such things) can help you to get it all working properly :-)