same fields from diff tables in Access

I have a databse with our computer, monitors, printers and misc equipmet in tables with the primary key being the Asset number assigned. What I want to do is to create a report that will list the assets. I want the report to list the assett numberand serial number, model, Description and where it is located. These fields are in all of my tables how can I combine them in a report. I tryed a query but all the fields from the different atbales are all on the same line.