• Outputting query results visually (eg as site plans)

    I have a site with a large number of boreholes and I need to assess the depth to a certain SPT value at each borehole across the site to zone it. Is it possible to create a query to identify the depth at each point and output this as a the labels on a…
  • Re: Display soil description in Sample Table

    Just looking at the SQL, there are some problems: <<Sql(SELECT (LITHOLOGY.DESCRIPTION) _ FROM LITHOLOGY _ WHERE (<<Sample.Depth>> < <<Lithology.Bottom>>) AND _ (<<Sample.depth>> >= <<lithology.depth>>) _ )>> should be: <<Sql(SELECT [LITHOLOGY…