I am attempting to sum a column on MS Access but when I do the value (hours) change which then affects the sum of hours column. What am I doing wrong?
When I activate the Totals button on the home ribbon, I do not see the Sum option. I enter the design view and activate the the totals button there. After doing so, I go to the hours column while still in the design view and change the group by to Sum, then i run the query. I return to the the database view and notice the values are different/wrong. When I go ahead and hit the drop-down button for the totals the Sum option appears then. But it is no use if the sum will be wrong. Any help would be great!!!! Please the screenshots below. I have zipped the actual database for anyone wanting to take a deeper look at what I've done wrong. I am very much new to Access!