Look up Query/Macro

[showe2295]

I have a table with hundreds of numerical values. I'm trying to create a way to look for a specific value in that table. If there is not a 1 for 1 match for that value, I'd like the query to look for 2 values that when added equal my original search if that is possible. Example: I plug in a value of 524, I'd like to see all the records that equal 524. If ther are no exact matches, I'd would like the query to search for two records that when added = 524 (400 & 124). For the multiple record matches, I need to match on the highest first. So if there are 2 possibilities (400 & 124 and 300 & 224) I want to see both but the 400 & 124 firstIf not 2, then 3 and so on. Each record in the table would have a unique value in addition to the numericall value.

[hertfordkc]

Your problem could be solved by iterating through a recordset. It wouldn't be pretty, but it would work.