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 2 3214
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Stefan Reiter |
last post by:
Hi,
I am trying to validate bank numbers
( the number that identifies a bank)
and bank account numbers.
Is there a certain algorithm or
do you know any generell rules like
how long the...
|
by: Amos |
last post by:
Dear Sirs
I am trying to build a cash flow software, first I thought to build one
table for each cash and bank account, but talking to some people they
suggested me to build one unique table for...
|
by: bobdydd |
last post by:
Hi Guys Can anyone help
I am trying to find a way to implement a running balance that will
re-calculate if the date order is changed, or if an earlier record is
changed like you might want to do...
|
by: Thapliyal, Deepak |
last post by:
Hi,
Assume I have a bank app.. When customer withdraws $10 from his accouint I
have to do following
--> update account_summary table
--> update account detail_table
Requirement:
either...
|
by: malcolm |
last post by:
Bank Charges Refunded
Free help to recover your bank or credit card charges from
www.bankchargesrefunded.co.uk
Its your money and its better in your pocket!
| |
by: Artificer |
last post by:
Is asp.net 2.0 appropriate to develop bank application or is intended
for less usage intensive environment. Are there any bank application
developed on it?
|
by: phong.lee |
last post by:
Hello, i'm a newbie in access. I'm looking for some kind of sample
database that does check reconciliation. Can someone assist me?
|
by: Jana |
last post by:
Greetings Access Gurus! I am working on an app to send batch
transactions to our bank, and the bank requires that we place an
effective date on our files that is 'one business day in the future,...
|
by: alexquisi |
last post by:
Hi,
I am newbie in optimization techniques and I need a little of help.
I want to take adventage of the open bank and open row policy
available in the processor (it can keep 4 banks open per...
|
by: cheongsiwei |
last post by:
Need some helps here >.<
The project i required to complete :
Create a base class Bank of a bank account with member functions to allow withdrawal, deposit and calculation of balance. ...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |