A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Saving Monthly Accounts and starting a new Month?



 
 
Thread Tools Display Modes
  #1  
Old May 22nd, 2010, 03:38 PM posted to microsoft.public.access.gettingstarted
Angeldelight
external usenet poster
 
Posts: 1
Default 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  
Old May 22nd, 2010, 04:19 PM posted to microsoft.public.access.gettingstarted
Ed Robichaud
external usenet poster
 
Posts: 90
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.