You just need to take the Query that you have working and make a few changes so that it will work on a Log report. Here is your Query: Select Count ([DISCONTINUITY].[Angle]) From [DISCONTINUITY],[SAMPLE] Where [DISCONTINUITY].[Depth] >= [SAMPLE…

If I understand what you are describing it sounds like the bottom of one layer is overlapping the top of the next layer. And, this happens when you copy an entire record and not just the description field. It sounds like you are getting overlapping…

Here are two expressions that will work on Log reports and Fence reports. Average Depth: <<Sql(_ SELECT AVG([SAMPLE].[Depth]) _ From [SAMPLE] _ Where [SAMPLE].[PointID] = '<<PointID>>' _ And [SAMPLE].[Group ID] = <<SAMPLE.Group ID>>; _ 0.000_ )…