Combining Multiple Reports

[Marie]

I would like to some how combine multiple reports. I have
created an asset inventory database to track my assets.

I would like to have a report that displays an employee
number as the grouping level and then have all assets the
employee has signed out to them appear under there
employee number.

I have an employee table that is liked to the individual
assets that each have there own tables.

Should I create queries for each asset table, cause I
don't want all the info in the tables. Just a couple of
fields. Can someone give me some tips on how I should
build this report? I have tried the wizard but I think
I'm doing something wrong.. Or should I be creating this
in design view instead?

 

[kip]

-----Original Message-----
I would like to some how combine multiple reports. I have
created an asset inventory database to track my assets.

I would like to have a report that displays an employee
number as the grouping level and then have all assets the
employee has signed out to them appear under there
employee number.

I have an employee table that is liked to the individual
assets that each have there own tables.

Should I create queries for each asset table, cause I
don't want all the info in the tables. Just a couple of
fields. Can someone give me some tips on how I should
build this report? I have tried the wizard but I think
I'm doing something wrong.. Or should I be creating this
in design view instead?

You need to perform a union of the separate queries.
Create each query to produce uniform output (employee
id,asset name). then create a new query, select SQL view
and type in:

table query1 union table query2 union table query3

and save it. (it can include as many tables as necessary).
The result will be a table:
emp 1, asset 1
emp 1, asset 2
emp 2, asset 2
emp 3, asset 1

now use that query as the basis for your report.

Kip