Insert Blank Line In Query?

From: MDW (MDW_at_discussions.microsoft.com)
Date: 09/29/04


Date: Wed, 29 Sep 2004 08:49:05 -0700

Not sure if this is possible. I've got a query that returns records like this
STORE_NUM NAME DIV_CODE
1 Main St. OA
2 Broadway OA
5 Sicily OA
6 Xenia OB
8 Trenton Av. OB
9 Platsville OC

Is there a way I can have a blank row in the query at each change in the
DIV_CODE? So it'd return this:
STORE_NUM NAME DIV_CODE
1 Main St. OA
2 Broadway OA
5 Sicily OA

6 Xenia OB
8 Trenton Av. OB

9 Platsville OC

Thanks.

-- 
Hmm...they have the Internet on COMPUTERS now!