Results 1 to 2 of 2
  1. #1
    Star Lounger
    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.
    Thanks again.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 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)
    ExpenditureDate (Date/Time)
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts