Report using two tables

[whjwilson]

Is it possilbe to build a report in Access pulling information from two tables? How can I do this or make it happen? Thanks.

 

[fneily]

When dealing with more then one table, you gather the information in a query and then use the output as input to the report. Sounds like you're new to Access. Before proceding, I recommend looking through a couple of books and taking some courses. Access is not like Word. You need to establish alot of basics first - like NORMALIZATION. In your case, you need to know the RELATIONSHIPS between tables and possibly how they're JOINED. If you're going to try and create an Access database without the proper training, I wish you luck.

 

[PHV]

Have a look at Query

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886