I would like to creates some queries that subtract the value from one day to the next. Not every day will have a value so it looks way to do this is with a sequential number field based on the date. I thought the way to do it was with the autonumber fields but not all of the values will necessarily be entered sequentially.
I'm thinking of some sort of query to sort by date and then with an expression to add sequencial numbers to another field.
Any ideas?
Thanks in advance
I'm thinking of some sort of query to sort by date and then with an expression to add sequencial numbers to another field.
Any ideas?
Thanks in advance