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
|
|||
|
|||
Percentage Calculations
I am currently keeping our church books on Excel but want to switch to
Access, which I have built other access data bases for other things which worked well. But, I am tring to build a data base for my church where a tithe amount is imputted then the appropriate percentage of that amount would go to 6 differant accounts. It gets more complecated when I also need a way to put in an "offering" to a particular account. Those accounts will need to be able to know what is available, have money drawn from them for differant expenditures. I can do this with an expression for each differant account but I cant figure out how to add money dirrectly to one account or take money out of it. fff |
#2
|
|||
|
|||
Book keeper in limbo,
I imagine you could have a Transactions table, with fields like this... TransactionID (?AutoNumber) MemberID (reference to the person contributing) Type (e.g. tithe, offering, expenditure) Account Amount With this model, it means that a tithe amount received would result in 6 records in this table, one for each of the split amounts for each account. But you would certainly be able to use fairly simple queries based on this table to provide account summaries, balances, summaries per member, etc. You would of course need to build some suitable forms for the user-friendly entry/editing of this data. -- Steve Schapel, Microsoft Access MVP Book keeper in limbo wrote: I am currently keeping our church books on Excel but want to switch to Access, which I have built other access data bases for other things which worked well. But, I am tring to build a data base for my church where a tithe amount is imputted then the appropriate percentage of that amount would go to 6 differant accounts. It gets more complecated when I also need a way to put in an "offering" to a particular account. Those accounts will need to be able to know what is available, have money drawn from them for differant expenditures. I can do this with an expression for each differant account but I cant figure out how to add money dirrectly to one account or take money out of it. fff |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date Calculations for Staff | [email protected] | General Discussion | 1 | December 10th, 2004 10:11 PM |
Combo Box using a Percentage Field | Rod | General Discussion | 3 | June 8th, 2004 02:11 AM |
Usinga a Percentage field in a Combo Box (can't get rid of *.00%)? | Rod | Database Design | 3 | June 8th, 2004 01:56 AM |
Percentage (%) sign in PivotTable... URGENT!!! | DDM | Worksheet Functions | 2 | May 11th, 2004 04:37 PM |