I am trying to create a query based on the fields on the table in the file provided. I know how to combine the fields Part Name and Part Family into one. What I need from is in the other fields how to create a query that after i group the records in the first two fields and then count the other records in the other fields based on the first two letters in each field. As an example the first field that would need to count is which gate broke. The first column in the query would take Part Name and Part Family and combine them into one column and the rest of the fields in the query would be Assy, DC, FI and MC. These would contain the count of each from the other fields in the query.