Group datasheet (1 Viewer)

[bodylojohn]

Hello again ;-)

I have a pretty basic question but I just don't seem to find the anwser.

I have a datasheet that looks like this:

Main_ID | ID | Number
1 | 1 | 45
1 | 2 | 65
1 | 3 | 345
2 | 4 | 145
2 | 5 | 75
2 | 6 | 25
2 | 7 | 145

I want to "group" Main_ID so it looks like this:

Main_ID | ID | Number
1 | 1 | 45
| 2 | 65
| 3 | 345
2 | 4 | 145
| 5 | 75
| 6 | 25
| 7 | 145

Its probably some small setting (i hope) but I just cant figure it out.

Hope you guys can help me again.

Thanks in advance

 

[John Big Booty]

You're not going to be able to do that using DataSheet view, the best you can do is Sort by Main_ID.

 

[John Big Booty]

You Could do it by using a From/SubForm Set and linking the two via the Main_ID. You would then have a page for each Main_ID with all the records sharing that Main_ID in your SubForm.

 

[bodylojohn]

You Could do it by using a From/SubForm Set and linking the two via the Main_ID. You would then have a page for each Main_ID with all the records sharing that Main_ID in your SubForm.

Yeah...I know about that option...
I don't like it layout wise.

But thank you very much for helping me!