Thanks, that is helpful. What about if I want to display other fields?
In the images shown here I have added another field called GID. The result I would like to see is the summed length for grouped by Certificate Number and Pipe Diameter. ie. For the two records with a Pipe Diameter of 375 in this example, the summed length for both records should be 9.8.
Can you assist me with this query? Regards Jane
