Group items in same account on same letter.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon - 11 Jan 2007 17:35 GMT

Serial Model Account Number Customer PostCode
1234 Widget A1 AC001 Banana plc B1 2QH
1235 Widget A2 AC001 Banana plc B1 2QH
1236 Widget A3 AC002 Orange plc D32 2DU
1237 Widget A4 AC003 Plum plc H62 2JU
1238 Widget A5 AC003 Plum plc B65 3KI
1239 Widget A6 AC005 Apricot plc J89 3WJ
1240 Widget A7 AC006 Melon plc K89 3JI
1241 Widget A8 AC006 Melon plc K89 3JI
1242 Widget A9 AC007 Lemon plc G67 2JI

We have the above data, in an excel sheet.

We need to produce seperate sheets from the list for each Customer Location
(i.e where account number & postcode are the same) I.e this would produce 7
seperate pages as follows.

As the mergedata file in sorted by account number then postcode, related
items are together.

What is the easiest way to acheive this in Word?
-------------------------
AC001
Banana plc
B1 2QH

1234 Widget A1
1235 Widget A2
--------------------------
AC002
Orange plc
D32 2DU

1236 Widget A3
-------------------------
AC003
Plum plc
H62 2JU

1237 Widget A4
--------------------
AC003
Plum plc
B65 3KI

1238 Widget A5
---------------------
AC005
Apricot plc
J89 3WJ

1239 Widget A6
--------------------
AC006
Melon plc
K8 3JI

1241 Widget A7
1242 Widget A8
-------------------------
AC007
Lemon Plc
G67 2JI

1241 Widget A9

Reply to this Message

Doug Robbins - Word MVP - 11 Jan 2007 18:08 GMT

That is not straightforward in Word. Better to use a report in Access.

However, see the "Group Multiple items for a single condition" item on
fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Serial Model Account Number Customer PostCode
> 1234 Widget A1 AC001 Banana plc B1 2QH
[quoted text clipped - 61 lines]
>
> 1241 Widget A9

Reply to this Message

Simon - 11 Jan 2007 18:15 GMT

I may have overcome this. I have added a new column to excel at the end of
each row.

If the value is TRUE then next row (record) should be added to the same
document.

When the value is FALSE a new document should be started?

I have tried used "Next Record IF" which works where there are multiple
records for the same account, however where there is only one record, it
doesnt print the next record - but the same record again?

Can I work round this?

> That is not straightforward in Word. Better to use a report in Access.
>
[quoted text clipped - 7 lines]
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

Reply to this Message