Q. Can I base a report on more than one table or query?

  • Thread starter Thread starter Jim Jones
  • Start date Start date
J

Jim Jones

Hi,

I wonder if it's "ok" to base a report or a form one more than one
table or query?

Can I use an unbound box, let's say, that will take a value from one
table field, and another field on that report to come from another
table or query?

If that's ok, then is the link between the two tables/queries
"automatic" AS LONG AS i have them set up in Relationships ?

Thanks,
Jim
 
This should be no problem. Just envoke the query builder
on your report by selecting Properties and than selecting
Data/Recordsource. Here you can pick the fields from any
tables or other queries you want and even create
calculated expressions in the extra columns.

As you indicated, as long as your relationships are set
properly it will know what values you want (provided you
also create the query).

Hope that helps. Good Luck!!!

Kevin11
 
Hi,

I wonder if it's "ok" to base a report or a form one more than one
table or query?

Can I use an unbound box, let's say, that will take a value from one
table field, and another field on that report to come from another
table or query?

If that's ok, then is the link between the two tables/queries
"automatic" AS LONG AS i have them set up in Relationships ?

Thanks,
Jim
Click to expand...

Only one query, or one table can be listed as the report record
source.

You can make a report out of more than one table by making a query,
using the tables as the query source.

You can use more than one query in a report by making a third query,
combining the fields from the first two, or making a fourth query
using the fields of the first three, etc.

Make sure all the tables have the proper relationships established in
the query.

If you have need for additonal data from a table/query not listed in
the report's record source, you can use the DLookUp() function to get
that data.
 
Back
Top