I have a database with a list of Names and 2 numbers and a date, like this:
Name | Num1 | Num2 |__ Date
_Billy_|__56__|___1__|_2/11/2010
_Billy_|__78__|______|_2/12/2010
...
When I add the second row, I want Num2 to automatically generate based on this:
If Num1>50, check Billy's Num2 from yesterday and add 1, else copy Num2 from yesterday
Thus Num2 should be 2 in the second row. I want to be able to do this with multiple names when I add new records every day. How can I do this?