Prev: Keeping DB structure but adding new tables
Next: update a table based on a sum query
From: Angeldelight on 22 May 2010 10:38
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 :)

From: Ed Robichaud on 22 May 2010 11:19
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" <Angeldelight(a)discussions.microsoft.com> wrote in message
news:3C76FD7C-C7BD-489D-8FD9-46DB8506122A(a)microsoft.com...
> 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 :)
>


 | 
Pages: 1
Prev: Keeping DB structure but adding new tables
Next: update a table based on a sum query