address field won't show up as an option for printing labels

[Guest]

I am trying to print address labels. The address field option is not showing
up when i am setting up the labels.

 

[ruralguy via AccessMonster.com]

Hi Cindy,
Have you included the Address field in the RecordSource of the Report?

 

[Guest]

Ruralguy,

I have no idea what this means.

I am not proficient at Microsoft Office and totally lost in 2007. I used a
template when I set up the database and the address field showed up as I was
adding new records. Then when I went to make labels all of the other fields
show up in the area to choose what I want on the label except the address
field.

If what you suggest could solve my problem would you be so kind as to give
me step by step directions that I could follow.

I don't understand why I can't get an answer simply by going to the help
section of access. Why don't companies give manuals with explict problem
solving capabilities? Instead people are forced to rely on the goodness of
strangers.

Thanks,

Cindy

 

[ruralguy via AccessMonster.com]

I don't know about ac2007 but in ac2002 I would open the Report in design
mode and then View>Properties>Data Tab and see what is in the RecordSource
row. If it is a query, which I think it is then press the "..." button on
that row and see if your field is in that query, If not then add it by
simply selecting it from the table and drag it down to the grid. It should
then show up when you gop to View>Fields from the design view of the report.