I'm trying to develop a database to catalogue LPs/CDs.
One thing I would like to do is to specify which decade a LP was released.
So I would have a simple table with
Decade/StartYear/EndYear.
60's /1960 /1969
70's /1970 /1979
etc. You get the gist.
In the main table, there would be a column with release date in a Month/Year format. eg. June-1975
I would like to then create a query that would look up the decade based on this release date.
Would this be difficult to do?
Thanks.