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
|
|||
|
|||
Suggestions on a Petty Cash table design
I was trying to come up with a setup for a Petty Cash table. The things it
must do the following: Date Money spent Where it was spent What is was spent for What the item is used for (Office supplies, maintenance, etc.) How much Has it been reimbursed 'possibly this field won't be necessary as if the When had a date it would have been. When it was reimbursed Now here is what has me thrown, how to keep track of starting amount and a running amount in the kitty. For example if we start with say $500 and spend $100 on several items I will need to know how much is left in petty cash at that time as well as any previously not reimbursed. Right now we are doing this in excel but would like to bring it into a single access table for ease of reporting on it. -- Thanks Joe Cilinceon |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help w/ table design | Tom | Database Design | 0 | August 12th, 2004 02:34 PM |
Semicolon delimited text query help | Al Guerra | Running & Setting Up Queries | 3 | August 12th, 2004 11:50 AM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Name not showing ID is | René | Setting Up & Running Reports | 11 | June 29th, 2004 01:40 AM |
Table design for a booking system | Brian C | Database Design | 2 | April 27th, 2004 03:11 AM |