I have a table with contract information. It's got Contract #, Customer ID, date contract was signed, quantity purchased. When customer makes purchase again system creates another contract with a new number. I need to compare each contract for the customer with the contract signed next time by this customer and calculated the difference in quantity purchased. Can anybody point me in a right direction?
Last edited:
