Grouping and not show duplicates

[Ewiz]

I have a two part problem right now. I have a Table Labeled "MAIN" where I have three fields that I would like to pull from, lets call them solution, version and testcasename.
Solution and the application name in which there will be some duplicating and also the version also when it pertains to the testcasename for example:
Solution Version TestCaseName
CAT 1.0 TestCase 1
CAT 1.0 TestCase 2
CAT 1.1 TestCase 1
FPT 1.2 TestCase 1
FPT 1.2 TestCase 2
FPT 1.2 TestCase 3
FPT 1.2 TestCase 4

Now this is what I am wanting to do:
Solution Version TestCaseName
CAT 1.0 TestCase 1
TestCase 2
CAT 1.1 TestCase 1
FPT 1.2 TestCase 1
TestCase 2
TestCase 3
TestCase 4

I created a query(SplashSort) to pull just the information stated above.
Under Solution I am trying to apply the string;
Select (Main.ID), (Main.solution) FROM (Main) GROUP BY (Solution) ORDER BY (Solution)
Select (Main.ID), (Main.Version) FROM (Main) Group BY (Version) ORDER BY (Version)
Select (Main.ID), (Main.TestCaseName) FROM (Main) Group BY (TestCaseName) ORDER BY (TestCaseName)

I was hoping that this should work, that or I am completely off the park and need to do some more reading. If I need to do some additional reading so I can get back up to speed in trying to understand the mess I got myself into.
:banghead::banghead::banghead::banghead::banghead:
Thank you

 

[CJ_London]

you need to put your examples in code tags to preserve the spacing.

I think you are wanting a result like this

CAT 1.0 TestCase 1
        TestCase 2
CAT 1.1 TestCase 1

In which case it would be extremely difficult to do in a query, but pretty easy in a report - use sorting and grouping and choose the display options you want