Table help

[waymond]

I have an non profit system I am supposed to move from excel to access. I have a tbale organizations with 18 different offices or auxillaries they have a field called brought forward which is the balance from last month then they enter in the money raised this month the sum of the two fields brought forward and raised this month are in a field total brought forward and raised then they enter in a field called disbursed this month which subtracts disbursed this month from total brought forward to go into calc field end month balance.

So it always starts out with the brought forward which is the end month balance from the previous month.(If they selected July then the previous June end month balance would be the brought forward? Is there a way to design the tables so they can do this? How many tables?

Thank You

 

[GingerR]

Hi--all of these calculations would be done on-the-fly, not stored in tables.

you'd have a table called Organizations, each row is one organization and it's data (i.e. Contact Phone, address, etc).

Then a table of Transactions or something like that:

TransactionDate
OrganizationID
TransactionType (Raised, Disbursed)

Transactions are entered into the Transactions table, then calculations are made and displayed in queries and reports.

Read up on basics of database development.


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html