I am sorry about all the confusion
Here goes:
I have a form set up that consists of these fields:
Customer
Job#
JobDescription
Status drop down choice of Proposal or Backlog
Materials
Labor
TransAccRec
TransLostProjects
Then I set up query that gives me a Quote based on Materials + Labor...
Only problem is, the Ending Balance is a calculated field that is derived from a Query, so altering the table, I don't believe will work, because that field does not exist there.
Any other thoughts???
I have a database that tracks jobs for a company, some in the proposal stage some already started.
I have a field that is called Status, with a drop down to choose either Proposal or Backlog.
The database tracks the Ending Balance, Cost, and Profit
along with some other things.
What I want to...
What I have is a database that is set up for tracking jobs, each record lists the job#, description, materials, labor, and quote, (this is the break down for the customer quote)
then it also lists in the same record the company material costs, and company labor costs, and the total cost...
I need to set up three different calculations. Is it possible to do it in one Query?
First I need to add two fields to get a quote total,
then I need to add two different fields to get a Cost Total
Lastly, I need to be able to give a %profit, by subtracting the Cost Total from the Quote, and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.