View Full Version : insert a space row


rynorem
01-09-2006, 12:37 PM
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
01-09-2006, 12:49 PM
Not in the query, but you can do it with grouping in your report (if that's what the query is driving.)