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  3221 
Sounds like homework.
"carlos" <cp*****@netvis ao.pt> wrote in message
news:ne******** ************@ne wsfront4.netvis ao.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*****@netvis ao.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 numbers have to be at least /most?
|
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 all bank and cash accounts,
putting one more column to identify each bank or cash account.
The unique table has this columns structure:
ID Date B/C account FinCode Description Debit
Credit
|
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 during a bank statement reconcile.
I am using the following fields
Date|Payment|Deposit|Running_Balance (tblTransactions)
|
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 both transactions should succeed or both transactions should
be rolled back in case of failure.
|
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,
excluding holidays and weekends.' I didn't want to build a table of
holidays that would have to be continuously updated, so I searched high
and low for a function that would tell me whether a given date was a
holiday, to no avail. I did find an...
|
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 bank, for a
total of 12 banks at a time) that I am using (AU1xxx), by locating
code, data, etc. on separete SDRAM bank and row boundaries.
The processor's documentation says that it can be done using the
|
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. Account should have a name, account number and type.
Create derived class Saving of a saving account, which allows overdraft up to $8000 and gives interest of 2% per annum. Create another derived class Current of a current account, which does not...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
