Thread: Add Weekly Data to Master

Hi, i am currently working on a database that will allow me to view weekly stats for upto a 1000 queues. Currently I have managed to build the 2 tables, 1st is the MASTER DB (showing all queue details) and the 2nd is a temp table that links a source file ( exported table) to the MASTER DB to show 1 weeks worth of data.

The problem i have is that i would like to add each weeks data to the MASTER DB in order to view a months worth of data but im not too sure how i can do this?

if somebody could please help, would really appreciate it.

Thanks in advance.

I suggest you use a query of the detailed table to extract the specific data you desire. This is the beauty of the power of Access. Use queries to get the information out of the tables. Creating and putting the same data in multiple tables violates the db normalization laws. First step in building a db is to make sure it is normalized. If you need some information on normalization, post back and I will lead you to a very good white paper.

Alan

alansidman, thanks for your response, really appreciate it. would you suggest that after i have ran the weekly data (temp table) then save this down with the Week Ending on a weekly basis and then having a ready made query that would combine the MASTER DB to the Weekly Data?

Btw would be happy if you could provide info on normalization.

Thanks in advance once again.

Here is the link on the white paper on data normalization
http://forums.aspfree.com/microsoft-...es-208217.html

As to your other questions, why save the query data, when you can run it at any time. That is how Access and other dBs should be employed. Keep your raw data in a table. Query the table(s) as you need the information. The mindset of a Master table and sub table makes no sense in a database. That is spreadsheet mentaility. If you want to succeed in using a relational data base, you need to lose the spreadsheet mentality when working in the dB.

I also urge you to Google "MS Access Normalization" and read as much as possible about this concept. Once you grasp this, it will make your work in Access easier.

I hope all this makes sense to you.