Adding values to equal total

[showe2295]

Hi. I'm trying to create a query that will take a list of quantites and add them to total a given quantity. I have a table with hundreds of individual records. I input a quantity and the query tries to find that exact quantity or multiple quantities that when added equal that quantity. I would also like it to use the least amount of records to do so. For instance, I have a quantity of 613. I'm looking for one of the following results...one entry in a table that = 613, 2 entires that toal 613 (e.g. 300 and 313), three that equal 613 and so on. I do not want 613 records of 1 to show up. Is this possible?
Thanks

[aytee111]

You need to group the records by something other than the quantity. Then you can total all the quantities for that group. Use the "Totals" for this. Once you have a query with all the totals you can easily find ones that equal any number.

[showe2295]

I don't think I clearly explained my issue. I'm looking to input a value, let's say 524. I need to have the query seach a list of individual numerical records and find one record that matches 524. If not, I'd like for it to find two records that when totaled = 524. If there is not two records, I need the query to continue to search for the fewest records to meet my original value.