Saturday, December 28, 2013

Query that provides combination of data that meet a certain criteria

Thanks Tim for the reply.


This actually does not solve the purpose. The problem is something like a zigsaw puzzle where i have the dimension of the final rectangle and a table where each row is a dimension(length in one column and width in another column) of a small piece which together form the bigger rectangle.


The problem is multiple combinations can be formed from available pieces. The list is a database in Microsoft Access and I am trying to write a SQL query to solve my purpose. I hope I am able to describe the problem.


Hoping for a positive reply.


Thanks


No comments:

Post a Comment