Impossible Query ?

[Middlemarch]

Can a query insert a blank row into it's output where the first 9 chars in Field1 change ?

[isladogs]

No
But you should be able to write a procedure to do so

[Middlemarch]

You mean build a new table, or something else - UDF the query calls ?

[CJ_London]

Do you mean something along the lines of the demo here?
https://www.access-programmers.co.uk...report.326715/

[xps35]

I don't understand. Insert one blank row where you want to change something? It won't be blank then. And, changed compared to what?

Please provide an example of what you want.