Can a query insert a blank row into it's output where the first 9 chars in Field1 change ?
Can a query insert a blank row into it's output where the first 9 chars in Field1 change ?
You mean build a new table, or something else - UDF the query calls ?
Do you mean something along the lines of the demo here?
https://www.access-programmers.co.uk...report.326715/
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.
Groeten,
Peter