Hi, I have got data that comes in by the day. I am looking to create a database that compares daily to week on week data for a year. I have put the data in access and linked it up. What I am trying to avoid is having 52 wks worth of tables in my file. I am hoping to be able to just pull up one week as defined by the date and one I do this I want it to populate the yearly data which is mainly % comparisons. My problem is how do I make this hold as in sticking so the next time the week is changed on the main comparison tables it doesn't affect the week on week and year comparison tables which I hope to drive graphs from too.

hope this makes sense to someone and thanks