finding a sum...

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Let's say I have a field called Amount, what I would like
to do is say:

If there are two Amounts that when added together =
$600.00 then display those Amounts

This might sound strange, but a co-worker requested it
and I'm not sure how to handle it. Any suggestions??
Thanks!

I am using Access 2002.

Michael
 
One thing I thought of was to maybe have a function that
would find all possible sums and filter out all of them
that are not 600.

for example:

Record1 + Record2
Record1 + Record3
Record1 + Record4
etc...

Record2 + Record3
Record2 + Record4
Record2 + Record5
etc...


Would this work?? If yes, any ideas how to get it to??


Thanks again
 
Back
Top