Database search and manipulation

[lockarde]

Good morning all,

I've hit a bit of a road block with some reporting and database automation and I was hoping one of you could help! I have a databse of product that I'm using to call certain data. For ease of reading the report I'd like to insert rows that have the summary of the product, then move on to the next product. Right now it's all manual, inserting rows, summing the cells above. For example:

SKU	Product Name	1st qtr	2nd qtr	3rd qtr	4th qtr				SKU	Product Name	1st qtr	2nd qtr	3rd qtr	4th qtr
1234567891011	Aloha T-Shirt (small, red)	3	13	27	9				1234567891011	Aloha T-Shirt (small, red)	3	13	27	9
1234567891012	Aloha T-Shirt (medium, red)	3	13	27	9				1234567891012	Aloha T-Shirt (medium, red)	3	13	27	9
1234567891013	Aloha T-Shirt (Large, red)	3	13	27	9				1234567891013	Aloha T-Shirt (Large, red)	3	13	27	9
1234567891014	Aloha T-Shirt (Xlarge, red)	3	13	27	9				1234567891014	Aloha T-Shirt (Xlarge, red)	3	13	27	9
1234567891015	Aloha T-Shirt (XXL, red)	3	13	27	9				1234567891015	Aloha T-Shirt (XXL, red)	3	13	27	9
1110987654312	Rain Jacket (small, red)	3	13	27	9				Aloha T-Shirt	Total	15	65	135	45
1110987654313	Rain Jacket (medium, red)	3	13	27	9		To This ->
1110987654314	Rain Jacket (Large, red)	3	13	27	9				1110987654312	Rain Jacket (small, red)	3	13	27	9
1110987654315	Rain Jacket (Xlarge, red)	3	13	27	9				1110987654313	Rain Jacket (medium, red)	3	13	27	9
1110987654316	Rain Jacket (XXL, red)	3	13	27	9				1110987654314	Rain Jacket (Large, red)	3	13	27	9
									1110987654315	Rain Jacket (Xlarge, red)	3	13	27	9
									1110987654316	Rain Jacket (XXL, red)	3	13	27	9
									Rain Jacket	Total	15	65	135	45

<tbody>
</tbody>

I'm thinking it might be easiest to just have a set number of rows, regardless of the number of products, there might be empty rows, but it'd be easy to just "copy the SKUs here, every 15 ros, insert name, sum rows here". Normally this wouldn't be an issue, but the extra text (size,color) that is included in the product name column throws me off with a search and copy.

I appreciate any insight you guys might have!

lockarde

 

[lockarde]

mumps, you've done it again! This works masterfully, thank you!

 

[mumps]

My pleasure.