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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.