MIS ACCESS Question. 12. For each Supplier, display the supplier Company, supplier City, Number of purchase orders placed with the supplier (give this a column heading of: Num Orders), and Submitted Date of most recent order for the supplier. Sort the results by alphabetically by supplier Company (A to Z). After you write your query, wave the query as (e.g., Wilbur Wildcat would save the query for this question as: WW_Q12). Write an explanation on how you approached solving this query (about 50-75 words). This should include how you decided upon the aggregate conditions. You can include which questions (1-10) helped you solve the answers. Take a screen shot of the query design window (including the query name, table, and fields area with all relevant conditions showing clearly and legibly). Paste your results in your answer template. Next click on the ! button to run the query.

This question might not actually be possible to solve without access to my specific classes access/data to use. But I don't really need a perfect answer for me. I more needed to know how to get the query set up with supplier and stuff to fit the question but actually properly search. Whenever I tried (I did not have any filters, and just grabbed names with the exact same names the question asks for) I got an SQL error and it said there were open joints that were too ambiguous to search. I don't know how to fix that and properly search with the query.

MUS304 Access assignment : Database-Users brosm.DESKTOP-139412H\Downloads, MIS204 Access_assignmentacdb (Access 2007-20-16 file format) - Access Danielson, Christian Alexander - (danielson1) DC File Home - COM View Create External Data Database Tools Help Design Tell me what you want to do 2 Ascending Y Selection New Totals Replace Descrnding Advanced Spelling Go 10 Filter Refresh Find BIU Andy Format Painter Remove Sort y Toggle Filter All X Delete - More Clipboard Sort & Filter Fecords Find Text Formatting Orders x Orders Status x Orders Tax Status X Products X Purchase Order Details X Inventory Transactions X = Order Details Paste 4 Select- Views All Acc... BE Suppliers X Relationships Relationships x 3 Purchase Order Status X - Products Order Details Purchase Order.. Order Details Sta. Status ID Status Name Customers Employees mes Inventory Tra. W Inventory Tra.. 111 Creer Details m Purchase Order Sta. 1 Status Suppliers Supplier IDs ID Product Code Product Nam Description Standard Cost List Price Purchase order Product ID Quantity Unit Cast Date Room Posted To Incent Inventory ID Orders Tax Status 1 Product ID Quantity Unit Price Discount Status 10 Date Alocated Purchase Cruer TI Order Details... Orders Tax Status Nams Purchase Orders Purchase order to Supplier ID Created By Submitted Date Creation Date Status Expected Date Shipping Fes Tares Payment Date Payment Amount Payment Method Orders Status I Orders Tax ! 111 Products Orders Status Targot Love Quantity Per Uni Discontinued Minimum Reen Category -1 III Purchase Ord III Purchase Ord. Status ID Status Nam. Customers Shippers Ti Purchase ord. al Shippers Suppliers Queries CD 210 C 911 Orders 1 order in Employee ID Customer U Employees PP Last Name First Name E- mail Address Jubtitle Business Phone Mobile Phone Address City State Zip Country Nates Suppliers ID Company Last Name First Name E-mail Address Job Title Business Phone Home Phone Mobile Phone Fax Number Address City State Province ZIP/Postal Code Country/Region Web Page Notes Company Company Last Name First Name Email Address Job Title Business Phone Home Phone Mobile Phone Fax Number Address Shipped Date Shipper Ship Name Shin Address Ship City Ship State/Provit Ship 218/Pustal Ship Country Shipping Fee Taxes Payment Type 0.04 CD 95 CD QG CD 97 CD 98 State/Province ZIP/Postal Code - CD 99 MUS304 Access assignment : Database - Users brosm.DESKTOP-139412H\Downloads, MIS204 Access_assignmentacxib (Access 2007 - 20-16 file formaty - Access Danielson, Christian Alexander - danisani) UC File Home Create External Data Database Tools Help Design O Tell me what you want to do Union i Insert Raws Insert Columns SQL FL Property Sheet Pass-Through Ix Delicte Rows Delete Columns Table Names View Run Select Make Append Update Crosstab Delete Add Totals Parameters Table Data Definition Tables Builder Returns All Results Ouery Type Ouery Setup Show Hide All Acc... . Products X Purchase Order Details X Inventory Transactions x x Order Details x Suppliers x Relationships x Purchase Order Status x Query1 X Add Tables X Tables Links Quenes All Customers Employees ames Inventory Tra. W Inventory Tra. 111 Crcier Details TI Order Details.. Order: area Orders Status A Orders Tax S... 1 Products III Purchase ord . Search Customers Employees Inventory Transaction Types Inventory Transactions Order Details Order Details Status Orders Orders Status Orders Tax Salus Products Purchase Order Details Purchase Order Status Purchase Orders Shippers Suppliers III Purchase ord. 1 Purchase ord.. al Shippers Suppliers Queries CD 210 C 11 Field: Table: Sort: Show Criteria cr: 1 .24 CD 95 CD QG CD 97 CD 98 Add Selected lablas CD 99 MUS304 Access assignment : Database-Users brosm.DESKTOP-139412H\Downloads, MIS204 Access_assignmentacdb (Access 2007-20-16 file format) - Access Danielson, Christian Alexander - (danielson1) DC File Home - COM View Create External Data Database Tools Help Design Tell me what you want to do 2 Ascending Y Selection New Totals Replace Descrnding Advanced Spelling Go 10 Filter Refresh Find BIU Andy Format Painter Remove Sort y Toggle Filter All X Delete - More Clipboard Sort & Filter Fecords Find Text Formatting Orders x Orders Status x Orders Tax Status X Products X Purchase Order Details X Inventory Transactions X = Order Details Paste 4 Select- Views All Acc... BE Suppliers X Relationships Relationships x 3 Purchase Order Status X - Products Order Details Purchase Order.. Order Details Sta. Status ID Status Name Customers Employees mes Inventory Tra. W Inventory Tra.. 111 Creer Details m Purchase Order Sta. 1 Status Suppliers Supplier IDs ID Product Code Product Nam Description Standard Cost List Price Purchase order Product ID Quantity Unit Cast Date Room Posted To Incent Inventory ID Orders Tax Status 1 Product ID Quantity Unit Price Discount Status 10 Date Alocated Purchase Cruer TI Order Details... Orders Tax Status Nams Purchase Orders Purchase order to Supplier ID Created By Submitted Date Creation Date Status Expected Date Shipping Fes Tares Payment Date Payment Amount Payment Method Orders Status I Orders Tax ! 111 Products Orders Status Targot Love Quantity Per Uni Discontinued Minimum Reen Category -1 III Purchase Ord III Purchase Ord. Status ID Status Nam. Customers Shippers Ti Purchase ord. al Shippers Suppliers Queries CD 210 C 911 Orders 1 order in Employee ID Customer U Employees PP Last Name First Name E- mail Address Jubtitle Business Phone Mobile Phone Address City State Zip Country Nates Suppliers ID Company Last Name First Name E-mail Address Job Title Business Phone Home Phone Mobile Phone Fax Number Address City State Province ZIP/Postal Code Country/Region Web Page Notes Company Company Last Name First Name Email Address Job Title Business Phone Home Phone Mobile Phone Fax Number Address Shipped Date Shipper Ship Name Shin Address Ship City Ship State/Provit Ship 218/Pustal Ship Country Shipping Fee Taxes Payment Type 0.04 CD 95 CD QG CD 97 CD 98 State/Province ZIP/Postal Code - CD 99 MUS304 Access assignment : Database - Users brosm.DESKTOP-139412H\Downloads, MIS204 Access_assignmentacxib (Access 2007 - 20-16 file formaty - Access Danielson, Christian Alexander - danisani) UC File Home Create External Data Database Tools Help Design O Tell me what you want to do Union i Insert Raws Insert Columns SQL FL Property Sheet Pass-Through Ix Delicte Rows Delete Columns Table Names View Run Select Make Append Update Crosstab Delete Add Totals Parameters Table Data Definition Tables Builder Returns All Results Ouery Type Ouery Setup Show Hide All Acc... . Products X Purchase Order Details X Inventory Transactions x x Order Details x Suppliers x Relationships x Purchase Order Status x Query1 X Add Tables X Tables Links Quenes All Customers Employees ames Inventory Tra. W Inventory Tra. 111 Crcier Details TI Order Details.. Order: area Orders Status A Orders Tax S... 1 Products III Purchase ord . Search Customers Employees Inventory Transaction Types Inventory Transactions Order Details Order Details Status Orders Orders Status Orders Tax Salus Products Purchase Order Details Purchase Order Status Purchase Orders Shippers Suppliers III Purchase ord. 1 Purchase ord.. al Shippers Suppliers Queries CD 210 C 11 Field: Table: Sort: Show Criteria cr: 1 .24 CD 95 CD QG CD 97 CD 98 Add Selected lablas CD 99