Labor Costing: I'm So Dead...

[JohnHoo]

So uh..., I'm new here. I work for a contracting company that specializes in Mechanical & Electrical engineering. We build really big buildings.

Anywho, part of my job here is to make the bureaucracy more efficient, or implement bureaucracy where there is none.

Couple days ago, my boss asked me to create an Excel spreadsheet to make calculating labor costs for a project more efficient. Right now, they're relying on good-old-fashioned educated guesses and calculators.

I did just that. I'm quite proficient at Excel, and the bossman was happy with it. Until now.

Today, he asked me to do exactly what I did in Excel, in Access. SHIT!

The only background I have in Access was two days of exposure in high school..., 6 years ago.



I have no idea what to do with Access, so I'll be needing all the help I can get. I still wish to deliver, and I have some clue as to how Access works. I just don't know how to get what I did in Excel in Access.

P.S. >> I did not lie on my resume about my "experience" in Access. I didn't even submit a resume.

Anywho, onwards to what I need to do:

I need Access to print out a report daily on how much the company is spending on each construction site. So we have workers (W) who are paid different rates depending on contract (R), working at the site for a period of time (T), at different projects (P).

So I have four variables. The bossman just wants a way to quickly generate a daily report on how much the company is spending on labor. This of course, needs to include overtime (oT). That makes it five variables.

Of course, the W, R and P variables need to be derived from a living list, since people join us or leave us from time to time.

I don't know where to start... Help?


Thanks for taking the time to read this.

[Access_Blaster]

Upload your excel sheet so people have an idea what your trying to do. Minus sensitive information.

[JohnHoo]

Upload your excel sheet so people have an idea what your trying to do. Minus sensitive information.

No problem. It's attached.

However, I renamed the extension into .doc. When you wanna open it, rename the extension .xlsm

Yes, it's a macroed Excel sheet. No viruses, I promise.

Basically, there are a bunch of sheets for calculation. However, the sheets of interest is "Administration View" and "Day Sheet". Basically, one of our managers will fill in the Day Sheet portion, and the bossman can see the results on Administration View.

P.S. >> Just in case no one understands it, "RM" here is the Malaysian currency. We are a Malaysian company.

[June7]

Review the 'sticky' thread tutorials here http://forums.aspfree.com/microsoft-access-help-18/

You are definitely going to have to reorient your frame of reference to work with Access as opposed to Excel for this effort. Will probably take quite a bit longer to get the Access equivalent functional. It is possible you might find Access is not the best tool for this.

Maybe take a look at some other efforts in this area
http://www.download32.com/access-est...-software.html
http://blog.softwareadvice.com/artic...mating-system/