First, yes, you're right.... your table structure is not normalized, and you're seeing just one of many problems of dealing with unnormalized data structure -- namely, the ridiculously complex expression that you need to use to get an average. What you need is a child table with four fields in it: tblHourTable HourID (primary key -- autonumber is fine) LinkingField