Hi all.
Im new to access, thus im here
I have a little mysql/php experience but am now trying to build a desktop app in access.
I am trying to make a Bill of quantities application for my self build house, which will take the material dimensions
To understand my question i will need to describe my tables and forms thus far, and what I am looking for my app to do, or at least for this element of it.
I have 2 tables
Table 1 (Materials)
Material name
Material Description
Unit of measurement
Sheet material (check box)
Timber Material (Check box)
Loose quantified material(check box)
then the fields that I want to pull into the calculations field on my form from this table
length
depth/height
width
area (calculated field) [length] * [height]
volume (calculated field [length] * [height] * [depth]
then the material supplied dimensions/quantitys
pallet/box quantity
amount per metre square
coverage per roll (insulation, polythene products)
Then I have some general fields for actually sorting out the purchase orders etc.
Area of house (just the area of the house in concern, ie roof, first floor...
Order date is required
Purchase order number
Table 2 is where the questions I want answered will go to get the dimensions from the house.
It has a few fields
Question ie, please enter the length of the perimeter wall? or
please enter the internal wall area of the external wall.
answer
So that's what I am trying trying to achieve (hope its clear as I need some help with the calculation to establish the quantity for each material. This is because the calculation is different for each material, but I just want 1 quantity field on my form or report, not one for each different type of calculation which would leave me with lots of empty fields.
Is it possible to have a field which would allow a different calculation for each material?
If you cant do this, any suggestions would be greatly appreciated.
Thanks in advance.
Im new to access, thus im here

I have a little mysql/php experience but am now trying to build a desktop app in access.
I am trying to make a Bill of quantities application for my self build house, which will take the material dimensions
To understand my question i will need to describe my tables and forms thus far, and what I am looking for my app to do, or at least for this element of it.
I have 2 tables
Table 1 (Materials)
Material name
Material Description
Unit of measurement
Sheet material (check box)
Timber Material (Check box)
Loose quantified material(check box)
then the fields that I want to pull into the calculations field on my form from this table
length
depth/height
width
area (calculated field) [length] * [height]
volume (calculated field [length] * [height] * [depth]
then the material supplied dimensions/quantitys
pallet/box quantity
amount per metre square
coverage per roll (insulation, polythene products)
Then I have some general fields for actually sorting out the purchase orders etc.
Area of house (just the area of the house in concern, ie roof, first floor...
Order date is required
Purchase order number
Table 2 is where the questions I want answered will go to get the dimensions from the house.
It has a few fields
Question ie, please enter the length of the perimeter wall? or
please enter the internal wall area of the external wall.
answer
So that's what I am trying trying to achieve (hope its clear as I need some help with the calculation to establish the quantity for each material. This is because the calculation is different for each material, but I just want 1 quantity field on my form or report, not one for each different type of calculation which would leave me with lots of empty fields.
Is it possible to have a field which would allow a different calculation for each material?
If you cant do this, any suggestions would be greatly appreciated.
Thanks in advance.
