Producing Tables

[NickH]

Hi

I am trying to merge the following table into a word
document.

Limit Line Freq Scale Amp Scale
ON LIN LOG
Value (MHz) (dBuA)
1 0.009 79.0
2 0.150 79.0
3 0.500 79.0
4 0.500 73.0
5 30.00 73.0

The only cells which are merged into the document from
access are the rows associated with the figures.
I now have no problems with the first Row(1), the data is
correct when merged into the table, but if I use <<NEXT
RECORD>> for the three fields in the next row down(2), I
get the following values in the table

2 0.500 73.0

Could some one advise me whatI may be doing wrong, please

Thanks


Nick Hyde

 

[Graham Mayor]

You need to set this up as a directory (catalog) merge. Put one row on the
page containing the three fields, then merge to a new document. The merge
will build the table. Do not use next fields for this.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[NickH]

Hi Grahame

Just to say thanks, it works OK.
All I need to do now, is to find a way for merging not
just one table onto one page, but from the Access table
gather the rest of the data in the table to merge out to
Word, i.e. the Table shown below
Session ID Number Segment Freq Amp
1 0 1 0.009 101.9999
1 0 2 0.15 78.99994
1 0 3 0.5 78.99994
1 0 4 0.5 72.99996
1 0 5 30 72.99996
1 1 1 0.009 88.9999
1 1 2 0.15 65.99999
1 1 3 0.5 65.99999
1 1 4 0.5 60.00002
1 1 5 30 60.00002
2 0 1 0.009 101.9999
2 0 2 0.15 78.99994
2 0 3 0.5 78.99994
2 0 4 0.5 72.99996
2 0 5 30 72.99996
2 1 1 0.009 88.9999
2 1 2 0.15 65.99999
2 1 3 0.5 65.99999
2 1 4 0.5 60.00002
2 1 5 30 60.00002

The table shows two Sessions (normally more), within each
session there are two Groups 0 & 1 each one forms a
table. From this what I am trying to achieve is to have
two tables per page so for session 1, there would be two
tables 0 & 1, with corresponding rows of data (Segment)1
to 5
The only point I can mention here is how we have or need
the Word document laid out, the tables would not go on
consecutive pages! therefore I need to find a way to
merge the specific Session with both tables at an
appropriate section of the Word Document.

I hope I have not confused.

Thanks

Nick

 

[Graham Mayor]

You can't do that. The only way I can think of would be to merge the two
tables separately and combine the resulting documents.
You could use a third document with Includetext fields to place the merged
table documents. It's a bit fiddly but should work OK.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Guest]

OK

I will have ago

Thanks

-----Original Message-----
You can't do that. The only way I can think of would be to merge the two
tables separately and combine the resulting documents.
You could use a third document with Includetext fields to place the merged
table documents. It's a bit fiddly but should work OK.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>





.