How to create 2 column MS Word document?

[stable]

Hi there,

I have not created a word document out of Access before.

I need to produce a 2 column MS word document report listing the results from a stored procedure. This file will be overwritten periodically.

Each column actually contains 2 fields - the name and amount. I would like the name to be left aligned and the amount to be right aligned.

There are also group headings in this report and these need to be bold. The most important point is that I want the data to appear down column 1 first before starting column 2.

Can anyone give me some pointers on how to get started?

Cheers
Stable

 

[flyover789]

Hi,

you could create a report in your access project, including all the alignments and formatting. this report could be output to word as a *.rtf file:

DoCmd.OutputTo acOutputReport, "yourreportname", "Rich Text Format", "c:\somefolder\somefile.rtf", -1

please note that 'graphical elements' like pictures, lines ... are not output to the *.rtf document.

And a question: what do you mean with

I want the data to appear down column 1 first before starting column 2

HTH,
fly

Martin Serra Jr.

http://www.mserrasystems.de

 

[stable]

Hi Martin,

Sorry I didn't make that very clear. I want a 2 column "portrait" report that lists the data in order down column one first before commencing column 2. i.e. I want 2 lists per page.

As far as I'm aware in Access reports the data can only be reported one record per line. I'm using Office 2003.

Have I missed something very obvious?

Cheers
Stable

 

[stable]

Hi there,

I've realised that I can make a 2 column report by starting with the label wizard (basically setting the report width to say 7.5cm will achieve this). But unfortunately the data still goes sequentially across the page rather than down.

cheers
Stable

 

[flyover789]

perhaps you could create two subreports, one for each 'column', and place them on your mainreport as you need ?

HTH,
fly

Martin Serra Jr.

http://www.mserrasystems.de

 

[stable]

Hi Martin,

Unfortunately the data needs to flow from one list onto the next and I do not know how much data to expect.

Any other ideas?

Cheers
Stable

 

[hymn]

Why not send as single then transpose in word manually

Hope this helps
Hymn

 

[flyover789]

Hi again,

I feal that it'd help us if you'd describe the datasource of your report in more detail. perhaps can you post the code of the stored procedure?

regards,
fly

Martin Serra Jr.

http://www.mserrasystems.de