Insert Blank Line In Query?
From: MDW (MDW_at_discussions.microsoft.com)
Date: 09/29/04
- Next message: ew: "Date range in crosstab query"
- Previous message: Allen Browne: "Re: Find Nearest Value"
- Next in thread: anonymous_at_discussions.microsoft.com: "Insert Blank Line In Query?"
- Reply: anonymous_at_discussions.microsoft.com: "Insert Blank Line In Query?"
- Reply: Tom Ellison: "Re: Insert Blank Line In Query?"
- Messages sorted by: [ date ] [ thread ]
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!
- Next message: ew: "Date range in crosstab query"
- Previous message: Allen Browne: "Re: Find Nearest Value"
- Next in thread: anonymous_at_discussions.microsoft.com: "Insert Blank Line In Query?"
- Reply: anonymous_at_discussions.microsoft.com: "Insert Blank Line In Query?"
- Reply: Tom Ellison: "Re: Insert Blank Line In Query?"
- Messages sorted by: [ date ] [ thread ]