Software

Ask something
Discussion Locked

Legend in an Access Report

0 helpful
1 reply

by audit

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have several tables that contain just numerical codes and the description of those codes. In reports that I create, which contain multiple code fields, I would like to include Legends of the codes in the report footer rather than including description fields in the body of the report.

I have copied and pasted the table contents into the report footer, and while the result was not bad, I would like the information to be dynamic rather than static as these codes tend to be updated or changed over time.

Does anyone have a better method than I described above?

1 reply

by mslizny

Am I correct in assuming that the descriptions of the codes are the part that you want to have as legends in the header or footer of a report? If the descriptions are a field in the table, you can put the description field in the header or footer, and if it has been changed since the last time you printed the report it will be updated from the current information.

This discussion is closed to new replies.