Create a query that will do the following: a. Create a table variable named Inventory with the
Question:
Create a query that will do the following:
a. Create a table variable named "Inventory" with the following information: Vendor ID Vendor Name Product Name Now the fun part
b. Declare and set a variable called "Find" that will be used later to find all items with "coffee" in the name.
c. Search the table variable for the product name that contains the word coffee within.
d. Branch if the VendorID is "Bob".
e. You will need a variable named "Product" that will hold the full Product name, once found.
f. You will need a variable named "Vendor" to hold the vendorname, once found. Note: you may want to use sub-queries to load the Product and Vendor variables, and to search for coffee.
g. The output should look like this: The Coffee maker is from Bobs Hardware
Using Microsoft Excel and Access 2016 for Accounting
ISBN: 978-1337109048
5th edition
Authors: Glenn Owen