By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,442 Members | 1,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,442 IT Pros & Developers. It's quick & easy.

Bank reconciliation

P: n/a
Hi.

Can somebody help me with this :

I have 2 tables :

tblA : 1,4,3,9,12,7,7,97
tblB : 1,2,2,9,3,3,3,3,14,71

How can i retrieve unmatched values, or unmatched sum of values

in this case i would match

1=1
4=2+2
9=9
12=3+3+3+3
7+7=14

i would like the result to be :

tblA: 3,97
tblB: 71

Thanks a lot
Carlos Alvarez
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Sounds like homework.
"carlos" <cp*****@netvisao.pt> wrote in message
news:ne********************@newsfront4.netvisao.pt ...
Hi.

Can somebody help me with this :

I have 2 tables :

tblA : 1,4,3,9,12,7,7,97
tblB : 1,2,2,9,3,3,3,3,14,71

How can i retrieve unmatched values, or unmatched sum of values

in this case i would match

1=1
4=2+2
9=9
12=3+3+3+3
7+7=14

i would like the result to be :

tblA: 3,97
tblB: 71

Thanks a lot
Carlos Alvarez

Nov 13 '05 #2

P: n/a
On Tue, 15 Feb 2005 23:33:17 -0000, "carlos" <cp*****@netvisao.pt>
wrote:
Hi.

Can somebody help me with this :

I have 2 tables :

tblA : 1,4,3,9,12,7,7,97
tblB : 1,2,2,9,3,3,3,3,14,71

How can i retrieve unmatched values, or unmatched sum of values

in this case i would match

1=1
4=2+2
9=9
12=3+3+3+3
7+7=14

i would like the result to be :

tblA: 3,97
tblB: 71

Thanks a lot
Carlos Alvarez

Try to do it.

What have you done so far?

We'll help you but we won't do it for you.
Greg Teets
Cincinnati Ohio USA
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.