2 Tables on 1 Report

[cperry88]

I would like to populate 2 different data tables on the same report. The top one would identify pricing detail for my products and my intention is to have the bottom table display misc. product detail. Is there an easy way to accomplish this?

[ItsMe]

Have you tried joining the tables with a query and using grouping and sorting in your report?

[cperry88]

No I have not. My understanding is that in doing this, my information would be populated on 1 table, with all relevant data being produced in column format. I hesitate to do this because of not being able to print everything out on one page. I would much rather have my page layout be Landscape, with a price table at the top of the report, then fill in the blank space below that with a table showing product information. I may not be understanding the grouping and sorting functions properly though. Access noobie by the way. Thanks

[ItsMe]

I always try and create reports based on a single query. If it is not possible then a subreport will be needed.

The idea is there needs to be a key value that relates the two tables. Create a query and join the tables using this relationship. Create a report and create groups to isolate certain columns. If details for your groups are overlapping and groups are not controlling your report the way you need it to, then look into a subreport.

[cperry88]

Thank you very much for your recommendation. I will certainly make an attempt at your suggestion. Thanks again! Fingers Crossed!!