Summarise Data

[TimTDP]

I need help summarising data!

Attached file include:
Access Database with contains a table and a query. The query is a summary of the data in the table
Excel Spreadsheet. The spreadsheet contains the same data, but also shows how I want to finally summarise the data from the Access query

If you look at the Access query, you will see that it contains sequential "StripNumbers" and that often the data is the same.
I want know how many "StripNumbers" contain the same data.

 

[jzwp22]

It sounds like you need something like this:

SELECT Count(tblCustomerQuotationProductCuttingList.StripNumber) AS StripsRequired, tblCustomerQuotationProductCuttingList.StripWidth, tblCustomerQuotationProductCuttingList.CutLength, tblCustomerQuotationProductCuttingList.ComponentMaterialId, tblCustomerQuotationProductCuttingList.ComponentMaterialDimensionsId
FROM tblCustomerQuotationProductCuttingList
GROUP BY tblCustomerQuotationProductCuttingList.StripWidth, tblCustomerQuotationProductCuttingList.CutLength, tblCustomerQuotationProductCuttingList.ComponentMaterialId, tblCustomerQuotationProductCuttingList.ComponentMaterialDimensionsId;

To use this, just create a new query, switch to SQL view and copy the above text into the window.