two tables queries one report

[psamu]

I would appreciate if anybody help on this. I have two different tables and queries. (I am using 2007 access) I want to create a report that shows both information in separate section. ( Above and below) Thanks

 

[SydneyGeek]

If the tables are related one to many, you can use a subreport to show records that relate to a main record.

Denis

 

[psamu]

These tables are separate, no connection with each other, but I tried to use as sub report, but access 2007 I don't know how to do that. I created separate queries for both tables, I created a report by using one of the query, now I just want to add another query as a sub report. thanks for the help.

 

[SydneyGeek]

If they are not related, a subreport makes no sense; nor does trying to add the data to the original report. Do they share a common field (a primary key in one of the tables)? If not, why not print the two reports separately -- or have I missed something?

Denis

 

[psamu]

Thanks. I was thinking, when user view/print this report, both will work at the same time.

I think, I will create a macro command to do the same.

Thanks again, appreciate your time.