I have a line layer together with a point layer representing a mark every 1m along the line. Essentially KPs along a cable route starting from say 0 to 50. As well as a point every 1m there is a point at the end of the line. For example 1, 2, 3, 4, 5 ... 47, 48, 49, 50, 50.4 if the line isn't exactly 50m in length.
A query of MOD(MP, 10)=0 will give me a point every 10m but doesn't include the last point.
How can I create a query that displays a point every nth value PLUS the end point.
