Hi Ken,

Thanks for your help. I will compare the two different approaches.

Regards,

Adrian

Ken, thank you so much. I now have more work to do understanding what you have done. The result set from your query is EXACTLY what I need.

As a minor...

OK Ken (et al), I have gone through Ken's solution.

In my first posting, I simplified the problem and gave you a very limited data set that included only wet mass...

Ken, many thanks for your troubles. It will take me a while to digest what you have done, but it runs perfectly with the correct answer for the first one.

Although...

Is there any reason why the above query would not return a recordset when using ADO through Excel VBA to open it ? I'm using an ODBC driver for SQL...

Hi Tom, thanks very much for your reply.

It makes perfect sense and I see what you are trying to do however I cannot get it to run.

I get an error...

Hi,

I am a great fan of using Excel for reporting.

I have made many similar reporting tools. With a little bit of extra VBA, you can easily format the returned...