Can someone assist me in forming a query. I've included a sample database.
My table has multiple fields however I want to use the fields BI_Part_nr, Competitor, Comp_Item_number, comp_price to create a query.
The table has multiple records which I want to consolidate to
BI_Part_nr (Group), competitor (Where Camozzi or Cmatic), field[comp_price_Camozzi]]
I was able to create sub queries, however I coudn't get all the data to populate in one record tied to BI_Part_Nr.