Question regarding sorting/Grouping/binding...

[Mimoss03]

Hello,



I do not have much experience in Access or SQL. I am not a DB Admin by trade. I am simply trying to create something in Access to help my day to day workflow. I've tried researching / Googling the answer, but i think i just dont know the correct keyword, etc to search.

Here is what i am trying to accomplish

I have a simple Table.
I want to "group" certain data items together. So if i have something like...

ID: 1 Item1
ID: 2 Item1_1
ID: 3 Item2_1
ID: 4 Item3_1
ID: 5 Item2
ID: 6 Item4_2
ID: 7 Item5_2
ID: 8 Item6_2
ID: 9 Item3
ID: 10 Item7_3
ID: 11 Item8_3
ID: 12 Item9_3



Now I want to keep each parent Item and each item inside the "parents" "binded" together somehow, so even if i re-sort them in the opposite order, each item stays in the proper place (under the set "Parent"). So taking the example above if it re-sort it, it should look like:

ID: 9 Item3
ID: 10 Item7_3
ID: 11 Item8_3
ID: 12 Item9_3
ID: 5 Item2
ID: 6 Item4_2
ID: 7 Item5_2
ID: 8 Item6_2
ID: 1 Item1
ID: 2 Item1_1
ID: 3 Item2_1
ID: 4 Item3_1


Does this make sense? Like i said, i am sure i dont have the lingo correct, so please let me know if i need to clarify something. Working on Windows 7 x64 with MS Access 2007

Thanks,

Mike

[amrut]

Create a report based on the data and use the group & sort feature to get what you want. Use the report wizard to get started.
https://support.office.com/en-us/art...rs=en-US&ad=US