Microsoft Office 365 Access 2016 Querying the Discover Science Database Using SQL

Lab 2

Step#3. Table Name is Item

Task: Display the item

number, description, and inventory value for all items. Inventory value is the

result of multiplying wholesale cost by the number of items on hand. Name the

computed field Inventory Value. Save the query as ITL 2 Step 3 Query.

Set up is as follows:

SELECT [Item Number], [Description], [Inventory Value], [Wholesale Cost] * [Items on Hand] AS [Inventory Value]

FROM Item

WHERE [Wholesale Cost]* [Items on Hand] =Inventory Value;

There is an error message in Where command (Syntax Error (missing operator) in query expression [Wholesale Cost]* [Items on Hand]= Inventory Value;Microsoft Access 2016

pur-new-sol

Related Questions