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...

Google+ offers ________ types of real-time chat

A) five B) three C) four D) two

Computer Science & Information Technology

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

Computer Science & Information Technology

Define decision making and describe its role in programming.

What will be an ideal response?

Computer Science & Information Technology

You can use the Swatches panel to change type color.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology