RE: Insert Blank Line In Query?

anonymous_at_discussions.microsoft.com
Date: 09/29/04 

Date: Wed, 29 Sep 2004 11:40:08 -0700

Have experimented with this after your reply. You can
export a report to Excel. If you make the bare-bones
report I suggested and leave an open Group HEADER (not
footer), the exported report will have a blank line
between groups. You will have to remove the leading blank
line (first header) and perhaps the column label, but you
get your blank lines between groups.

Let me know if this works for you.

>-----Original Message-----
>Unfortunately, this isn't going into a report. It's going
to be exported to
>Excel, where currently I have to go into the workbook and
manually enter
>those blank lines (rows) myself. Was hoping Access had
some way to do it for
>me.
>
>Thanks though.
>
>"anonymous@discussions.microsoft.com" wrote:
>
>> Maybe the simplest thing to do is create a bare-bones
>> report based on the query and grouped by DIV_CODE. If
all
>> you want is a simple list, you can turn off the group
>> header and simply open the footer up a linespace high.
>>
>> Just a thought.
>>
>> >-----Original Message-----
>> >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!
>> >.
>> >
>>
>.
>

Relevant Pages

  • Re: Newbie really need help, data report
    ... I'm not sure when you say header, if you mean the Titles or Names of the ... where the report expects six fields in the records and Nulls are allowed. ... Sometimes, also, I then open the Excel document using early-bound ...
    (microsoft.public.vb.database.ado)
  • Re: why>?
    ... Just because PDF is more popular than SNP; ... Emailing a dynamic report is easier than emailing PDF files.. ... Excel is ALWAYS less efficient than Access. ... e) multi-user functionality - being able to work on the same report / ...
    (microsoft.public.excel)
  • Re: BCWP and BCWS
    ... Were you able to add the Tasks to Row labels in Excel? ... Report Filter, add to ROW Labels and Add to Column Labels. ... editing the report and inserting Actual Costs, Tacks AC, Task ... calculates actual duration and remaining duration. ...
    (microsoft.public.project)
  • RE: Get parameter dates in heading
    ... sheet but it creats a new report and the alignment gets all messed up ... It actuall creates a new Excel spreadsheet. ... Dim varGetFileName As Variant 'File Name with Full Path ... Dim strLeftRange As String 'Used to format range references ...
    (microsoft.public.access.externaldata)
  • RE: Get parameter dates in heading
    ... sheet but it creats a new report and the alignment gets all messed up ... It actuall creates a new Excel spreadsheet. ... Dim varGetFileName As Variant 'File Name with Full Path ... Dim strLeftRange As String 'Used to format range references ...
    (microsoft.public.access.externaldata)