Moderator
Windows 10 
Access 2010 32bit
It would be better if you attached a copy of the database with only a few records in zip format.
I'm not following your table structure.
Your SumOfLength and Price for that "overallsize" has to be multiplied; and "overallsize" seems to be the link between your info.
Novice
Windows 10 Access 2016
Hello. Well I have decided to do this through Excel finally by connecting the Database (specifically) the queries which makes a lot easier to add a column with a formula. I wanted to thank you for your support and advice.
Update Price change without changing price in past records, HELP! (newbie here)
=[Price per hour]*[Number of hours] delivers 0 in the column Sum total.
Posting Permissions
Reply With Quote