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@...>
>
Tidak ada komentar:
Posting Komentar