How can I deal with footnotes in a report?

S

smccarvi

I am moving from Excel to Access and trying to figure out how I can deal with
footnotes. One idea I had was to make the footnotes a field in the table, and
display the footnote field in report's footer. I've tried doing this but do
not see my footnotes when I print. Any ideas what the problem is? Any other
suggestions to deal with footnotes?
 
J

John Vinson

I am moving from Excel to Access and trying to figure out how I can deal with
footnotes. One idea I had was to make the footnotes a field in the table, and
display the footnote field in report's footer. I've tried doing this but do
not see my footnotes when I print. Any ideas what the problem is? Any other
suggestions to deal with footnotes?
Click to expand...

Footnotes, in my mind, apply to documents. Access doesn't handle
documents - it handles database tables, which are conceptually
different!

What is your table structure? What is the relationship between a
record in your table and the footnotes (plural I presume??) for that
record?

I strongly suspect you'll need at least two tables, and a
Sorting/Grouping setup in the Report to display the document on one
section, and the associated footnotes in another section.

John W. Vinson[MVP]
 
S

smccarvi

Thanks for the help so far, I made a little progress. I have set up two
tables. One with my data, which is grouped. I have a second table with
footnote numbers and text which is linked to the first table.

I inserted a subreport in the main report at the footer for the grouping.
The only problem is that only one footnote (last last one) appears per
grouping when I print.
 
J

John Vinson

Thanks for the help so far, I made a little progress. I have set up two
tables. One with my data, which is grouped. I have a second table with
footnote numbers and text which is linked to the first table.

I inserted a subreport in the main report at the footer for the grouping.
The only problem is that only one footnote (last last one) appears per
grouping when I print.
Click to expand...

Rather than a Subreport, I'd suggest basing the Report on a Query
joining the main table to the footnote table. It's not clear from your
description how the two tables are linked - do you have a Primary Key
in the data table, and a matching foreign key in the Footnote table?
If not, that would be the proper method, IMO.

Given that, you can create a Query joining the two tables on this pair
of fields. In your Report, use the "Sorting and Grouping" dialog to
display a Group Header for the data; put the data table field (or
fields) in this header, and the footnotes in the Detail section.

John W. Vinson[MVP]
 
Top