Search results

Hi, I'm trying to add subtotals onto my query in an additional column, The Criteria are other values from the current record and I'd like to add values from the whole query, example: very basic table with Dates and Quantites, I would like a total of all the quantites on and before the date...

I currently have 2 excel spreadsheets, one is relatively stable data referring to manufacturers of parts, order numbers etc, the other is more dynamic as it records data of individual shipments to and from me The problem is I currently have to enter most data twice as it needs to go onto both...