Mailmerge from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 06 Mar 2006 17:20 GMT

I am trying to create a report from a MS Access database. I'm using the
Directory style. My problem is many of the fields repeated items which I do
not want showing.

Sample of data:

<<Name>> <<Address>> << Order#>> <<Total>>
joe CT 12 $30
joe CT 24 $45
joe CT 101 $55
joe CT 102 $30
Sam VA 20 $18
Sam VA 32 $125
Pete VA 43 $16

What I'm trying to do is remove the repeating info so the report looks like
this:

Name Address Order# Total
joe CT 12 $30
24 $45
101 $55
102 $30
Sam VA 20 $18
32 $125
Pete VA 43 $16

I would appreciate some guidance. Thanks,

Steve

Reply to this Message

CyberTaz - 06 Mar 2006 20:47 GMT

Have you tried modifying the Properties of the Access Query? Set Unique
Values to Yes.

If the report is that simple, you may be better off to generate it as an
Access Report & use the Office Links button to Publish it to Word as an RTF
(which can then be edited & saved as a doc).

HTH |:>)

> I am trying to create a report from a MS Access database. I'm using the
> Directory style. My problem is many of the fields repeated items which I do
[quoted text clipped - 26 lines]
>
> Steve

Reply to this Message

Steve - 07 Mar 2006 01:16 GMT

I am even less familiar with access queries tham I am with mailmerge. In the
querty, where would I set the Unigue value?

Steve

> Have you tried modifying the Properties of the Access Query? Set Unique
> Values to Yes.
[quoted text clipped - 35 lines]
> >
> > Steve

Reply to this Message

Doug Robbins - Word MVP - 07 Mar 2006 20:43 GMT

I don't think Unique values in a query will give you what you want, but what
I would do is just use a report in Access.

If you want to persist with trying to do it in Word, 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

>I am even less familiar with access queries tham I am with mailmerge. In
>the
[quoted text clipped - 52 lines]
>> >
>> > Steve

Reply to this Message

CyberTaz - 07 Mar 2006 22:07 GMT

Doug -

You're absolutely correct, I misinterpretted the request.

The use of an Access Report would be the better way to go... set the Hide
Duplicates property for the Name field & the Address field to "Yes". Then
output it as a Word doc.

Regards |:>)

> I don't think Unique values in a query will give you what you want, but what
> I would do is just use a report in Access.
[quoted text clipped - 64 lines]
> >> >
> >> > Steve

Reply to this Message