One main report from multiple reports ?

[skocev]

Hi, i need some help.



I have 3 tables, 3 forms and 3 reports. I need to make one "main" report that will show only 2 filed from each report, totaly 6 filed.
Any idea?

Thanks you all in advance.

[pbaldy]

Depending on your specifics, a query that joins the 3 horizontally, a UNION query that joins them vertically, or subreports using the existing queries and reports.

[skocev]

Thanks you for you'r replay, but i cannot understand your awnser.
i'm beginer in access, so please if you can to explan me

[pbaldy]

I would say that the answer was vague because the question was vague. I don't know enough about your application to be any more specific.

[pbaldy]

From the description in your email, you want data side-by-side, like

Laptop Name, Laptop User, Workstation Name, Workstation User.

though frankly I'm still not sure. I'm not sure how you would achieve that look, since there's no common field the tables share that would let you relate them. If you want

Laptop Name, Laptop User
Workstation Name, Workstation User
Server Name, Server User

you would use a UNION query to pull data from the 3 tables together.