Hello experts ,
i have an access database and a table . In this particular table i store dates as long with other data in its columns . All i want to do is when i insert a record to the table ( which stores records using descending order for the dates field) is to make the following comparisons :
1. The top date should be compared to the current year and will return the result of current_year - top_date (integer)
2. The second record below the top date should be compared to the top_date like : top_date - second_date and i get the result (integer)
3.the third record should be compared to the second like second_date-third_date and i get the result (integer)
This should be done for all records of the table until EOF.
Can you help with this ?