Sorting\Grouping question from a newb

[jcampbell]

Hi everyone. Sorry if this has been covered but I am new to the forum and relatively new to dabase's and Access. I have been given a database that I need to try and group and run some reports on. The database was generated by a third part project and is broken up into tables. So one table list all of the class rooms and the specific information about them, number, name, area, etc. Another table called furniture list each individual piece of furniture for the room so for example for room 103 it list 12 individual lines of a chair. What I am doing in my report is simply creating a section in the report called furniture that I want to list out all of the items found in that room so I want to see chair, desk, projector, etc. in a list. What I am getting is that it will generate say 12 Room 103 pages for each chair so it still reports them all separated. Is it possible to just make a report that has a section in it that list this stuff out.



Sorry if I am not making myself clear. Like I said I am new and am not even sure how to ask my question.

Thanks for the help in advance.

[orange]

I suggest you research Normalization. Your tables do not exist independently of each other.
You really need to have some appreciation of database concepts before you attempt Reports.
There seems to be a link(relationship) between ClassRoom and Furniture along this line:

ClassRoom----contains--->Furniture (a 1 to many relationship)

Good luck, and Google can help -- search Normalization