Greetings,

I use a home made accounting system. I am developing this myself because I learn about the nitty-gritties of Access while doing this.

I am trying to make a budget table. I have some periods (not necessarily 12, can be 10 can be 13) and a number of accounts.

I have a one dimensional table where each record contains data on account Number, period, debit and credit.

I want to represent this table in a two dimensional form where the account numbers are on the left and periods on the top. This is kind of a pivot table or crosstab.

However neither of these views allow me to enter data.

Can anybody recommend me a good way of doing this?

Thanks
Kamil