How to stop ID Numbers appearing in Access label reports.

Copper Contributor

I'm a total Access novice. I just created my first table and used the label wizard to generate a Report from it for address labels (in Avery L7159 format, 24 labels to a sheet - 3 columns of 8 labels). It works perfectly except that the ID numbers, 1, 2 etc, are shown on every label immediately before the titles, so instead of getting "Mr & Mrs John Smith" I get "1 Mr & Mrs John Smith" etc. How do I make them disappear?

 

0 Replies