If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Horizontal" list box???
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 |
#2
|
|||
|
|||
"Horizontal" list box???
Kamil
What you describe sounds very much like a spreadsheet. Are you certain that you need to use Access to do this? -- Good luck Jeff Boyce Access MVP |
#3
|
|||
|
|||
"Horizontal" list box???
Yes. Only the budgeting part would be easily achieved by a spreadsheet. All the other aspects of an accounting system like company accounts, general ledger, payables, receivables, order handling etc. etc. would require a more sohisticated database system.
Thanks Jeff BTW. I am afraid I sent the message two times due to internet failure. Please disregard the other question. Kamil "Jeff Boyce" wrote: Kamil What you describe sounds very much like a spreadsheet. Are you certain that you need to use Access to do this? -- Good luck Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|