In MS ACCESS 2002, I have a rather large database of information. The current system I have just inherited has a table designated soley to maintaining a list of dates and their antiquity compared to today. Ex:
08-01-2006 | 1-2 Years
08-01-2007 | >1 year
Every month we have to update the value for that months dates (changing from >1 year to 1-2 years) manually.
Question, isn’t there a way for me to perform that function using SQL statements? I need to generate a report regarding the currency of active records. I need to know how many active records are 4+ years ole, 3-4 years old, 2-3 years old, etc.
how could I do this without having to manually update a table of dates and currencies?
