A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Suggestions on a Petty Cash table design



 
 
Thread Tools Display Modes
  #1  
Old December 22nd, 2004, 09:23 PM
Joe Cilinceon
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 11:15 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.