Creating Report on two tables that are linked

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,
I am a novice access user who is looking at someone else's application.
They have a Post Table and a Comments table. There is an id field in the
Post table that links to a Post_Id field in the comments table. When I open
the Post table, there is a blank field on the far left that has a plus or
minus sign. If I click on the plus sign, it appears to open values from the
Comments based on these two fields. In the Post table there is a Body field
that has information that people have typed in. In the Comments table is
also a Body field that has information. This access database comes from an
offline copy of a web site application. A user on the website creates a Post
which feeds into the Post.Body field. Someone else will then add a comment
to that post which feeds into the Comments.body field. What I want to do is
to create an Access report that has both the body sections from both tables
(The post and the comments from each body field). Can someone tell me how to
do this?

Thanks,
 
ChuckW said:
Hi,
I am a novice access user who is looking at someone else's application.
They have a Post Table and a Comments table. There is an id field in the
Post table that links to a Post_Id field in the comments table. When I open
the Post table, there is a blank field on the far left that has a plus or
minus sign. If I click on the plus sign, it appears to open values from the
Comments based on these two fields. In the Post table there is a Body field
that has information that people have typed in. In the Comments table is
also a Body field that has information. This access database comes from an
offline copy of a web site application. A user on the website creates a Post
which feeds into the Post.Body field. Someone else will then add a comment
to that post which feeds into the Comments.body field. What I want to do is
to create an Access report that has both the body sections from both tables
(The post and the comments from each body field). Can someone tell me how to
do this?

Thanks,
Click to expand...

Chuck, I don't understand what your database is about (Jobs or Mail?) but if
you have a linked table then put them both into a query in Design View. Join
the ID fields as in the table (if they don't join automatically) and then
base your report on this.

If, for instance, you have one Post and many Comments on each post. Then put
all the items from the Comments table into the Query grid and then, from the
Post table, put any items that *are not* in the Comments table (so you would
put PostID from the Comments table but not PostID from the Post Table).

Click on this query, choose Insert, then Report. Use the Report Wizard to
help you choose the fields you want to see in your report.

Evi
 
Back
Top