I may be able to make something like that work. The challenge would be in doing a breakdown of labor costs, material costs, etc. Also, hey want hours input from each worker daily with a running total of hours (labor) to quickly compare to estimate to see how they are doing. If I set up pre defined lists and limited input choices for the different resources then sorting could be easier.
Thanks for the input!
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> When I have created an application like this, I considered materials, people, and equipment as "resources". I used one table with resources used vs the job number. Every resource had a units and rate. Estimated and actual could be stored in the same table with a field that identified estimated/actual.
>
> Duane Hookom
> MS Access MVP
>
>
>
>
> To: MS_Access_Professionals@yahoogroups.com
> From: avgjoe64@...
> Date: Wed, 5 Oct 2011 01:23:04 +0000
> Subject: [MS_AccessPros] Re: New file uploaded to MS_Access_Professionals
>
>
>
>
>
>
> I'm trying to remember what I learned years ago, but haven't used in quite a while.
> My database (EstimateDB) is to calculate an estimated job costs, and to track the actual costs associated with a job. On the estimate, I need to be able to add the estimate hours and the estimate materials costs to get the total estimate cost. Problem is sometimes there may only be labor and no materials, and since my query sees the "null" in the material total I don't get a total for the estimate.
>
> Same thing with the actual side- I will have hours, but not always OT hours, per diem, or motel costs (etc, etc...)
>
> I need help to structure this to get the math to work correctly.
>
> Thanks in advance,
> Joe
>
> Using Access 2010.
>
> --- In MS_Access_Professionals@yahoogroups.com, MS_Access_Professionals@yahoogroups.com wrote:
> >
> >
> > Hello,
> >
> > This email message is a notification to let you know that
> > a file has been uploaded to the Files area of the MS_Access_Professionals
> > group.
> >
> > File : /2_AssistanceNeeded/EstimateDB.accdb
> > Uploaded by : avgjoe1964 <avgjoe64@>
> > Description : Estimate to Actual cost DB
> >
> > You can access this file at the URL:
> > http://groups.yahoo.com/group/MS_Access_Professionals/files/2_AssistanceNeeded/EstimateDB.accdb
> >
> > To learn more about file sharing for your group, please visit:
> > http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
> > Regards,
> >
> > avgjoe1964 <avgjoe64@>
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar