Report from multiple tables

[Michael57]

I want to make a report that uses data from 4 tables. How can I do this. I just want to bring the data in from the 4 tables and make some simple calculations but I want to show the original data and not the just the final answer.

 

[Lilliabeth]

You can either make a query and use the query as the record source, or during the first step of the wizard, choose one of the tables, select the fields you want and then choose another table and select the fields you want, continue this until you have selected all the fields and only then click 'Next' to go to the second step of the wizard.



Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[dhookom]

Lilliabeth's answer assumes the tables are related one to many from one to the other to the other... If the tables aren't related like this then you need to provide more information than just "uses data from 4 tables". We would need to know how/if the tables are related.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lespaul]

The Understanding SQL Join article below will also assist you.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi