It's been quite some time since I've posted to these forums. I'm currently involved in a rather robust database project, and can't quite get my head around how to structure it.
Basically, I have a single table of users. Each day, each user will supply a single value. I want the database to be able to then track these values over any period of time among any subset of users. So, it can look at all users over the past year, or one user over the past week... that sort of thing.
I don't know how to store these daily values. Any ideas?