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
You might also like to view...
Google+ offers ________ types of real-time chat
A) five B) three C) four D) two
In a typical system design specification, in the _____ section, start-up processing, initial data entry or acquisition, user training requirements, and software test plans are specified.?
A. ?system environment B. ?executive summary C. ?system components D. ?implementation requirements
Define decision making and describe its role in programming.
What will be an ideal response?
You can use the Swatches panel to change type color.
Answer the following statement true (T) or false (F)