SQL QUESTION - Using Date functions to retrieve information

By fitrpilot ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums