The purpose and scope of my database hasn't changed, but I'm realizing it's a big project for a beginner in Access.
I will be using at least four tables, an inception to date data table, a fund list, an org list and a line item list. The inception to date table will contain a fund number, an org number, an account number, an account title, and columns for budget, expenditures and encumbrances (which are type of accounting transactions). The fund list will tell me the name (title) of the fund number in the inception to date table. The org list will tell me the name (title) of the org number in the inception to date table. The line item table I will use to sub-total specific account numbers in the inception to date table.
I'm envisioning a report by org and fund which sub-totals budget, expenditures and encumbrances by line item and calculates the remaining budget balance. I'm hoping I can create a macro in Access which prints this data automatically for every fund/org combination.
Subscribe to:
Post Comments (Atom)
2 comments:
Wow, this does sound as a complex project. I hope you succeed in it and learn as much as you can.
The idea with the macro printing all combinations is great.
This is beginning to sound like an excellent and very useful project!
Post a Comment