Prev: Access Many to Many relationship
Next: auto number
From: Jazz on 27 Dec 2009 21:58
Very good advice as well. Thank you Steve, I value your contribution. I am
thankful for your help.

"Steve" wrote:

> I meant Projected Cost and Actual Cost not to have spaces! I also agree with
> Duane that you don't need Amount Saved!
>
> Steve
>
> "Steve" <notmyemail(a)address.com> wrote in message
> news:%23Y5lTB1hKHA.5604(a)TK2MSFTNGP04.phx.gbl...
> > Hello Jazz,
> >
> > Consider adding an expense category table. You probably spend your money
> > repeatedly on many of the same things such as electric, gas, telephone,
> > gasoline, etc so consider adding an expense item table. You also might
> > consider having an expense table and an expense detail table. With this in
> > mind you would have the following tables design:
> >
> > TblExpenseCategory
> > ExpenseCategoryID
> > ExpenseCategory
> >
> > TblExpenseItem
> > ExpenseItemID
> > ExpenseCategoryID
> > ExpenseItem
> >
> > TblExpense
> > ExpenseID
> > ExpenseDate
> > Comments
> >
> > TblExpenseDetail
> > ExpenseDetailID
> > ExpenseID
> > ExpenseItemID
> > Projected Cost
> > Actual Cost
> > Amount Saved
> >
> > Steve
> > santus(a)penn.com
> >
> >
> > "Jazz" <Jazz(a)discussions.microsoft.com> wrote in message
> > news:8E948DBC-C44D-4DE5-9D6E-BA2E0C7B939C(a)microsoft.com...
> >>I am creating a database to track what I spend my money on. I am planning
> >>to
> >> include the following fields in my table.
> >>
> >> Expense ID
> >> Expense Category
> >> Purchase date
> >> Expense Item Description
> >> Projected Cost
> >> Actual Cost
> >> Amount Saved
> >> Comments
> >>
> >> Considering my intention to track what I spend my money on,what do you
> >> think
> >> of my table design? Would you recommend different field names,
> >> additional
> >> field names, or keep the ones I have?
> >>
> >
> >
>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Access Many to Many relationship
Next: auto number