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
|
|||
|
|||
Saving Monthly Accounts and starting a new Month?
Hi Everyone,
I really enjoy the Access Database System it has helped me a lot with my accounts but I must be doing something wrong because, I keep opening new databases for each month instead of it following on from the previous month and using the same "Categories!." So my question is How do I save the previous month and let it be stored, and start a new month on the same system or page but without adding up what has been put in the system... If you know what I`m on about. Thank you Angeldelight... melting in the UK weather |
#2
|
|||
|
|||
Saving Monthly Accounts and starting a new Month?
Hard to advise without some info about your tables, but sure sounds like a
bad data structure - more like an Excel workbook where each spreadsheet tab is one months data. Let's use your checking account as an example: tblMyChecks TransactionID AccountID TransType TransDate Amount etc.... This one table can store all transactions from all accounts for all dates. You display and report a single account's records for a single month by using a query to filter the transactions. Look at some of the existing sample databases in Access for tips on how they structure and relate tables. "Angeldelight" wrote in message ... Hi Everyone, I really enjoy the Access Database System it has helped me a lot with my accounts but I must be doing something wrong because, I keep opening new databases for each month instead of it following on from the previous month and using the same "Categories!." So my question is How do I save the previous month and let it be stored, and start a new month on the same system or page but without adding up what has been put in the system... If you know what I`m on about. Thank you Angeldelight... melting in the UK weather |
Thread Tools | |
Display Modes | |
|
|