General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Marking records in table
I have a receivables table and I want to flag them so I can move them to a history table or I want to
change the amount owed.
Here is an example of my data
Acct_num;Price;Inv_date
1;40.00;06/27/01
1;40.00;07/27/01
The customer pays 60 dollars. I want to flag the oldest date as paid and then replace the next one with
the remaining amount owed which would be 20 dollars. This is just an example of what I need to do. The
oldest record needs to be changed first and then continue on. Any ideas on how I could do this?
TIA,
Tyler
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only