I really need help on solving the following problems. I appreciate any input.
Please refer to schema in the attached file.
Customer with the highest order amount on orders with 5 or more different items
Get Items with Qty greater than 10 per order. Select OrderID, OrderDate, CategoryName, ItemName and Item Qty.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.
A Microsoft Access subform is used to show relevant calcul…