Running Calculation on Query

[isladogs]

I'm sorry but I can't make sense of the criteria used to obtain these results from your latest query. I've restored 2 fields to try & make sense of it but it didn't help

Suggest you adapt the formula used in JHB's subquery approach or in my DSum approach to get the answers you want.

Good luck

 

[jmak_1214]

It is not quiet clear for me what you want, can you show it in a printscreen or Excel sheet the result you want, (using the data you've provide)?

I'm sorry but I can't make sense of the criteria used to obtain these results from your latest query. I've restored 2 fields to try & make sense of it but it didn't help

Suggest you adapt the formula used in JHB's subquery approach or in my DSum approach to get the answers you want.

Good luck

It is quite hard to explain. In any cases, thank you for all the help.

It works for me right now with the SampleData3.zip.

I was just trying to have 1 query instead of 2.