Select unique values from multiple fields

[MrDummy]

Hello,

I have an issue. I have a query with three fields that containt double values. I want to have the unique values (could also be text and not only numbers) from these three fields. The values come directly from a table and not from another query. If possible I would like to have it in the same query and not to make a seperate query. The unique values are then used for dispalying pictures so every picture comes up once.

In the attachement the unique values are then 4.3 5.1 5.2 6.1 8. The maximum unique values in these three fields is 8.

[CJ_London]

try

SELECT DISTINCT * FROM
(SELECT Label1 FROM myTable
UNION SELECT Label2 FROM myTable
UNION SELECT Label3 FROM myTable) AS tbls

[MrDummy]

Perfect runs smooth. Many thanks