Roll up query or table

[Yoni Hasid]

Hello,
I would like to create a table that will roll up Employee #s to corresponding Department #s. I currently have one table with all the data but would like to create a table that shows each Deparment # record and all subrecords with employee #s under it (group by, list?) Is there a way to do it via query?
Thank you.

[Rabbit]

You can just sort by the department number.

[NeoPa]

It sounds like you're looking for a subform or subreport. Your table structure seems to be like a spreadsheet rather than a database though. Have a look at Database Normalisation and Table structures.

You should also understand that a table is a definition of the data as well as where that data is stored. By their very definition, they are not able to store data of different structures.

[Yoni Hasid]

Thank you. I wanted to clarify. I would like for my table to look like the one on the attached image.

[NeoPa]

But what you see there is not a table as such Yoni. It's two linked tables that, because of their linkage, Access knows how to display in that fashion.

Essentially it's the sort of thing you you can achieve with a subform on a form (as I mentioned in post #3).

[Yoni Hasid]

Thank you this is helpful !