Originally Posted by
June7
I looked at the PsychologicalStateTracker.mdb file. A basic principle of relational database is 'enter raw data, calculate on report'. With that in mind, I don't understand the need for 3 tables for Comparison data. I also don't understand the Average fields in each table. Seems to me should be only daily records and the Weekly and Monthly comparison data could be summarized with aggregate queries of the daily data. Along the same line, the Average data could be calculated when needed. Granted, weekly is probably most difficult time period to aggregate, but it is doable.