OK, I think I went off in the wrong direction. Your data sounds far
more abstract than I appreciated and may not actually be relational.
OLAP and multidimensional databases could be a better model for your
circumstances.
I'll bow out gracefully and leave you with a link and a 'good luck':
Programming OLAP Databases from Microsoft Access Using DSO:
http://msdn.microsoft.com/office/und..._accessdso.asp
Jamie
--