Grouping files

[Higgs]

i have a combo box that looks something like this:

Date: 2010-10-10 1:19:22 TypeOfFile: 0000001-D00
Date: 2010-10-10 1:19:55 TypeOfFile: 0000001-D00
Date: 2010-10-12 4:14:12 TypeOfFile: 0000002-D01
Date: 2010-10-12 4:15:11 TypeOfFile: 0000002-D01
Date: 2010-10-14 2:22:10 TypeOfFile: 0000001-D00
Date: 2010-10-14 2:28:15 TypeOfFile: 0000001-D00

** Multiply every TypeOfFile with 1000 to get the correct size of data.

Since displaying it like this makes it quite difficult for the user to get a good overview (due to the large amount of same files). How do i make this more easy to view for the user?

Is it possible to make the combo box look (group) something like this:

Date:2010-10-10 1:19:22 to 1:19:55 TypeOfFile 0000001-D00
Date:2010-10-12 4:14:12 to 4:15:11 TypeOfFile 0000002-D01
Date:2010-10-14 2:22:10 to 2:28:15 TypeOfFile 0000001-D00

I have tried the 'GROUP' command but that one groups i.e. all *-D00 files together which i dont want.

appreciate any help

thanks

[Rabbit]

Take whatever dataset created that, group by the type of file and do a min and max on the date.

Edit: nevermind. That won't work. I didn't notice the break in sequence. You'll have to use a VBA function for what you want to do.

[Higgs]

allright thank you,

think i came up with an idea.

Cheers