Can a report have multiple data sources?

[wisemax]

Can a report have multiple date sources? For example, TotalRevenue is
from query Revenue, TotalExp is from the query Exp?

Or all its text boxes must get data from the same source?

Thanks in advance.

HZ

 

[tina]

a query can have only one RecordSource - but that record source may be a
query or SQL statement that is based on multiple tables, and/or based on
multiple other queries that may be based on one or more tables. you can also
use subreports to display linked data in a report. and you can always use
domain aggregate functions such as DLookup(), DSum(), and DCount() in
unbound textbox controls on a report, to display specific values from other
tables or queries.

exactly what technique(s) you use in any given report is dependent on the
tables' structure and relationships, and what the specific report needs to
contain.

hth