Sum of records to a given result

[mbertuol]

Hello,

I need to know which records sum up to a given value. Lets say I have the following entries in a table:
1 = 78
2 = 56
3 = 120
4 = 24
5 = 480
6 = 89
7 = 489
8 = 98
9 = 54
10 = 569
If I provide to the query the value 752, I need to know which records sum this amount. In this example I would need the records 3, 5, 8, and 9 displayed.

I am not sure if this can be done in a query or if I should use VBA.

Any help is truly appreciated.

Thank you,

Mauro

 

[mbertuol]

Any ideas at all?