C
Chance
New to Acces Need HELP!! I want to build a data base that
will track job cost. I need help in figuring out the best
way to set up the tables. I have a current way of tracking
it in excell. I use 3 data sheets and then one summary
sheet. I want to use access for it's abilty to use forms
and reports. The colums for the sheets I use are as
follows:
PO LOG: Date, PO#, Vendor, Description, Cost, Ordered By,
Category
Rental Log: Item Description, Vendor, PO#, Start Date,
Stop Date, Stand by days, Min. Charge Amount, Min Charge
Days, Additional Daily Charge, Additional Days, Current
Cost, Estimated Stop Date, Estimated Days Left, Forecasted
Cost(It does the calculations from the current date for
current days used and for the forecasted cost)
Payroll: Day#, Date, Position, Hours, Total
Thanks,
Chance
will track job cost. I need help in figuring out the best
way to set up the tables. I have a current way of tracking
it in excell. I use 3 data sheets and then one summary
sheet. I want to use access for it's abilty to use forms
and reports. The colums for the sheets I use are as
follows:
PO LOG: Date, PO#, Vendor, Description, Cost, Ordered By,
Category
Rental Log: Item Description, Vendor, PO#, Start Date,
Stop Date, Stand by days, Min. Charge Amount, Min Charge
Days, Additional Daily Charge, Additional Days, Current
Cost, Estimated Stop Date, Estimated Days Left, Forecasted
Cost(It does the calculations from the current date for
current days used and for the forecasted cost)
Payroll: Day#, Date, Position, Hours, Total
Thanks,
Chance