Comments

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

I have a report that changes daily.

Once the report is generated each day. I would like
to establish a comment field. I want to provide and
explanation of the differences for a particular day.

I designed the report using the wizard. Is it possible to
add a field called comments in the design grid and if so
whenever I input a comment will it remain until the item
is removed? (I don't want to retype the same information
each day).
 
Consider creating a table into which you can enter the Comments, with an
Active/Inactive indicator, then create a simple Report to contain the
currently-Active comments and embed it in the Report footer, if you only
want one "comments area" per Report.

If you want a comment per record, explaining things, then you need to
identify the comments with a foreign key to the pertinent record, include
the comments table in the report query, and use a text box in the Detail
Section with CanShrink/CanGrow properties set to Yes.

Larry Linson
Microsoft Access MVP
 
Back
Top