Help with database

[Guest]

I am working on a database for my roofing company. It consists of three
tables one with a list of products, prices, and coverage areas for each
product etc., one with a list of buildings/projects, and one that records
which materials are being used on a particular building/project. I have a
form that allows me to choose my products and add them to each
building/project. My next goal is to be able to input how much material i
need of a particular product and have access output the quantity i need of
each product based on its coverage area. For example, a certain product's
coverage area is 10x100(1000sqft is in the products table) per roll. I would
like to be able to say i need 30,000 sqft and have access output 30 for the
number of rolls i need. Ideas suggestions help is very much appreciated.

 

[Rick Gittins]

You can create formulas on screens or reports to do the calculations. If
you need help let me know.

Rick

 

[Guest]

I am using this formula: Line Total:
CLng(([Quantityin]/[coveragearea])*([product.existingprice])).....this allows
me to divide how much material need by the quantity the product's coverage
area then multiplying that by the unitprice. However, on my form the line
total box reads #error....how do i solve this?
Thanks

 

[Rick Gittins]

I see one issue right away. [product.existingprice] Are you trying to
access the price that is in the products table?

Rick

I am using this formula: Line Total:
CLng(([Quantityin]/[coveragearea])*([product.existingprice])).....this
allows
me to divide how much material need by the quantity the product's coverage
area then multiplying that by the unitprice. However, on my form the line
total box reads #error....how do i solve this?
Thanks

You can create formulas on screens or reports to do the calculations. If
you need help let me know.

Rick

 

[Guest]

yes

I see one issue right away. [product.existingprice] Are you trying to
access the price that is in the products table?

Rick

I am using this formula: Line Total:
CLng(([Quantityin]/[coveragearea])*([product.existingprice])).....this
allows
me to divide how much material need by the quantity the product's coverage
area then multiplying that by the unitprice. However, on my form the line
total box reads #error....how do i solve this?
Thanks

You can create formulas on screens or reports to do the calculations. If
you need help let me know.

Rick

I am working on a database for my roofing company. It consists of three
tables one with a list of products, prices, and coverage areas for each
product etc., one with a list of buildings/projects, and one that
records
which materials are being used on a particular building/project. I have
a
form that allows me to choose my products and add them to each
building/project. My next goal is to be able to input how much material
i
need of a particular product and have access output the quantity i need
of
each product based on its coverage area. For example, a certain
product's
coverage area is 10x100(1000sqft is in the products table) per roll. I
would
like to be able to say i need 30,000 sqft and have access output 30 for
the
number of rolls i need. Ideas suggestions help is very much
appreciated.