Programming Question

[MrElam]

Could someone help me with this? I would like to create a program (VBA or VB6) where I could enter a number in an input box and have it give me a list of numbers (probably stored in a table) that add up to this total. There would probably be about 20 numbers in the table at any one time, but not all the numbers would be used for the total. The problem is that the only way I can think of is to go through every possible combination of 20 numbers (which would take a few days). Does anyone know a mathematical trick to do this fast? Thanks.<br>

<br>

<br>

MrElam@aol.com<br>

 

[DougP]

1. Use Access<br>
2. Create a table<br>
3. Add your numbers<br>
4. Create a query to find your numbers<br>
5. Create areport based on that query and put a totals box in the footer.<br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>