S
Sonja
Hello
I have a database that is updated daily with transactions that are either
added deleting or changing information. I have a table that contains acct
no. status(which is add delete or change) date and person doing transaction.
I need to be able to update the adds to deletes with matching account numbers
from another table however if there is more than one add then I would like to
keep it an add and only change the other to a delete. In other words I want
to only change one delete per one add. What I am coming across is that all
of the adds change to deletes. Is there a criteria that I can put in to do
this?
I have a database that is updated daily with transactions that are either
added deleting or changing information. I have a table that contains acct
no. status(which is add delete or change) date and person doing transaction.
I need to be able to update the adds to deletes with matching account numbers
from another table however if there is more than one add then I would like to
keep it an add and only change the other to a delete. In other words I want
to only change one delete per one add. What I am coming across is that all
of the adds change to deletes. Is there a criteria that I can put in to do
this?