Sorting labels to print from Report

[Anne Nwokoye]

I've tried so many ways in Access 97 to get ONLY a certain
field to print from a Report in label form, but nothing
works. For instance, I have a large table with many fields
from which in Reports I would like to select ONLY one
field or another to get labels from. i.e., file name:
Hampshire County Human Service Agencies; to sort by Police
Depts. (Field 10). Does anyone have a foolproof method for
getting results like I want? Thanks so much.

Anne

 

[Larry Linson]

Queries, for which Access provides a point and click Query Builder, are the
way to retrieve selected Fields from a Table. There are report templates,
including several for labels, that you can access via the Report Wizard (you
might have to visit http://www.microsoft.com and look for additional
templates to download to get the proper one for your labels). Sorting and
grouping in Reports is handled by the, no surprise, Sorting and Grouping
dialog -- in design view of the Report, right-click on the top left-most
little square, and choose Sorting and Grouping.

I've answered multiple questions here, but I'm not 100% sure that I answered
the questions you have. So, follow up or clarify here in the newsgroup,
please, not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP