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

Steve

"CyberTaz" wrote:

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 |:)

"Steve" wrote:

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