Using multiple tables in a report

  • Thread starter Thread starter Mike Waters
  • Start date Start date
M

Mike Waters

Hello,
On the report I created, I currently have my information
(or the user's information) hard coded onto the report. I
then decided to make up a table that would hold this
information. I would like to know how I can now take the
information from this table, and put it on my report. I
tried using a text box, and making the default value equal
to the information if represents, but this didn't work.
Any suggestions would help.

Thanks,
Mike Waters
 
If the information is related to the information that is included on the
report, you might make a Query that joins the pertinent tables to use as the
RecordSource of the Report. You might be able to use a Report / Subreport
combination.

But with no more specific information than what you gave, it's hard to say.
Could you clarify, and be more specific?

Larry Linson
Microsoft Access MVP
 
Hello,
What I'm working on is a report that will have my
information, such as name, address, and E-mail address on
it, along with information for the person it is being sent
to.
What the database is going to be used for is to keep
track of contacts I make through my Amatuer radio. From
these contacts I want to be able to print out "QSL" cards
to send to them. On the cards I list things such as my
name and address, and amatuer callsign. These things
(except my address is I move) will always stay the same.
There are a few other "hard coded" parts such as my
location that could change, if I'm traveling when I talk
to the person. After designing it for my own use, I
thought about making it more dymanic and putting my
information in a table. The problem I then had was
getting the information from both tables to the reprot. I
tried making a query that pulled from both tables, but
when I ran the report I didn't get any records. Any
suggestions would help.

Thanks,
Mike Waters
 
For some reason, using a Query is working this time. When
I first tired using a Query, I wouldn't get any of the
records, so I would always have a blank reprot. Today
when I went back in it now works.
 
One method is to use an unlinked sub report.

Make a report based on your table and set it up to display the information in
the manner you wish.

Now include the report as a subreport in whichever section (Report header,
footer) that you want the data to appear. DO NOT LINK the subreport.
 
Back
Top