Some idea for my report!

[dbertanjoli]

Hello there,

I am trying to create some report and I don't even know how to start. I have several tables. One contains universities' names and other 6 certain categories. Each of these 6 tables has at least 6 fields. So, my intention is to create a simple spreadsheet format. University field should be a column heading and other categories from other six tables should be row headings. All those tables contain some statistic info. And I don't need to sum or count the data. How can I achieve this?

 

[jlkrk1]

The first thing you will want to do is create a query joining your necessary tables together on the appropriate fields. Once you have done this, create your report off of the query. It is hard to explain how to create the report you're looking for, not knowing what you would want to show. Try using the report wizard and select your query for in the wizard for your report to be based off of.