The formula for Gross Profit is Net Sales - Cost of Goods Sold. You want to find the gross profit next year given a 2% gross profit growth rate. You enter the following formula into a query, but your numbers do not seem to be right. Why?
[Sales Data]![Net Sales] - [Sales Data]![Cost of Goods Sold]*1.02
A) The formula should be multiplied by 102%.
B) A formula cannot contain a field reference and a constant.
C) Access does not recognize decimals.
D) The formula does not specify the right order of operations.
D
Computer Science & Information Technology
You might also like to view...
The ________ performs addition, subtraction, multiplication, and division and also makes logical and comparison decisions
A) motherboard B) system unit C) control unit D) arithmetic logical unit (ALU)
Computer Science & Information Technology
A computed ___________ is a calculation that a DBMS performs, similar to the way a spreadsheet computes a formula.
A. table B. field C. record D. relationship
Computer Science & Information Technology