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.

Re: Combining multiple entries over a range in MS Access 80 80

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

Re: Combining multiple entries over a range in MS Access 80 80

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.