Solved

# Multiple Line Items to Calculate Square Footage

Posted on 2003-12-12

I'm building an access 2000 database for our construction division to use as an estimating tool. They are currently using an excel spreadsheet that has over 200 pages.

I have built an entry screen for the individual items they use in projects, but now I need to build an entry screen for things that are calculated on square footage per linear foot, and the unit cost is based on the guage of the materials being used.

I do understand the calculation, I'm just having a hard time deciding how to get the information in to perform the calculation.

Ex.

Duct A Duct B Total Linear Feet 90 degree elbow Offset

are some of the column headings in the excel spreadsheet.

The spreadsheet then takes the total linear feet and there is a multiplier used that tells how many units of each item is needs for each linear foot, and then the total of all these items is added together and multiplied by the unit cost. There are also different guages for each of the column heading items that are based on gauge and then a calculation is done to calculate total man hours needed.

I feel I can write the code for the calculations, I just can't figure out how to design a form to get the information in.

Any suggestions?