Results 1 to 2 of 2
Thread: Track Expenditures (2003)
2007-02-07, 16:04 #1
- Join Date
- May 2004
- Asheville, North Carolina, USA
- Thanked 0 Times in 0 Posts
Track Expenditures (2003)
Did not know how to search this so I thought I would ask. I want to track expenditures on a monthly basis but also have a summary sheet to show all months with totals. I want to use a dedicated expenditure code to where the money was spent.
Can anyone point me to a past post, website, or give me a few ideas.
2007-02-07, 16:22 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Track Expenditures (2003)
I'd use one table to store all the expenditures. It is then (relatively) easy to filter the data for a single month and to summarize the data in various ways.
The table would have at least these fields (you can. of course, use other names)
ExpenditureID (AutoNumber, the primary key of the table)
ExpenditureCode (Number - Long Integer, see below)
ExpenditureDescription (Text, for a description, if necessary)
You can add other fields as needed. The ExpenditureCode would be linked to a table listing the codes and their meaning.