I need help with access2000!!!!
I have a table with cost and revenue by contract. 1 contract can have multiple revenue sources. I created a query to sum total revenue by contract. That works fine. I also want to calculate gross profit (gp) dollars and gp% based on my sum total revenue field and it wont’ work.
Someone told me that I can’t perform a calculation on a calculated field and suggested I use the make-table function in my query to refresh my data into a new table. Then base a 2nd query on the new table and perform my calculations. My gp dollars calculations works, but when I do the second calculation, the % don’t tie out. What am I doing wrong? Is there a restriction on the # of calculations performed in a query?
Thanks
I have a table with cost and revenue by contract. 1 contract can have multiple revenue sources. I created a query to sum total revenue by contract. That works fine. I also want to calculate gross profit (gp) dollars and gp% based on my sum total revenue field and it wont’ work.
Someone told me that I can’t perform a calculation on a calculated field and suggested I use the make-table function in my query to refresh my data into a new table. Then base a 2nd query on the new table and perform my calculations. My gp dollars calculations works, but when I do the second calculation, the % don’t tie out. What am I doing wrong? Is there a restriction on the # of calculations performed in a query?
Thanks
