Creating reports using two tables

[Nathan Vanderslice]

Well, I figured out how to get the contents of of two tables together in a
report and it's just a matter of working out the actual layout. My problem
is that the only thing that shows up in preview, are the field headings or
captions, and the text in the combo boxes. One of the two tables has already
gotten information entered in, but the other table will be done later when
needed. Why is the info in the completed table not showing up? The tables
are linked. Also, how do I get the report to show one record per page?

 

[Arvin Meyer]

Well, I figured out how to get the contents of of two tables together in a
report and it's just a matter of working out the actual layout. My problem
is that the only thing that shows up in preview, are the field headings or
captions, and the text in the combo boxes. One of the two tables has already
gotten information entered in, but the other table will be done later when
needed. Why is the info in the completed table not showing up? The tables
are linked. Also, how do I get the report to show one record per page?

I am assuming that you are using a query as the recordsource of your report.
The tables are JOINed, not linked. JOIN is the keyword used in your query to
show how the 2 tables are connected. If, in the design view of your query,
you right-click on the join line between the 2 tables, you should get a
context-sensitive menu which offers the choice of "Join Properties"

Open the Join Properties and choose either the second or third choice with
ALL of the records from the table you know to contain the data.

To get one record per page group on the record's id value and choose to show
the group footer. Set its height to 0, but in the Format tab of the
section's property sheet choose to Force New Page After Section
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access