RE: [MS_AccessPros] Re: New file uploaded to MS_Access_Professionals

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@mac.com
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]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/