I am working on MS ACCESS database and I have to combine multiple entries in the table into one as for example,

min 1 2 3 8 9 11
max 2 3 5 9 10 12

and the result should be

min 1 8 11
max 5 10 12

How do I achieve this using SQL query in MS ACCESS? Please help.

Can you explain a little more, perhaps showing some actual data you want to run this against?

I need to generate objections against these values with another table.And if I dont do this ,redundancy is seen in the resulting table.The actual data is almost the same except the difference in the numbers.