insert a space row

[rynorem]

Our inventory is based on a number system for example:

101 01
101 02
101 03
102 01
102 02
102 03
102 04
etc
What do I have to put in the query to make it skip a space after each group set. For example after 101 and after 102 etc. thanks.

 

[Sergeant]

Not in the query, but you can do it with grouping in your report (if that's what the query is driving.)