469,342 Members | 6,455 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,342 developers. It's quick & easy.

Roll up query or table

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.
Nov 21 '11 #1
5 4388
Rabbit
12,516 Expert Mod 8TB
You can just sort by the department number.
Nov 21 '11 #2
NeoPa
32,182 Expert Mod 16PB
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.
Nov 21 '11 #3
Thank you. I wanted to clarify. I would like for my table to look like the one on the attached image.

Attached Images
File Type: jpg Rollup table.jpg (30.2 KB, 1312 views)
Nov 21 '11 #4
NeoPa
32,182 Expert Mod 16PB
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).
Nov 22 '11 #5
Thank you this is helpful !
Nov 28 '11 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by dummie_q | last post: by
7 posts views Thread by Nicolae Fieraru | last post: by
1 post views Thread by Michel Rousseau | last post: by
1 post views Thread by fhiemstra0507 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.