Access is a database tool - not a numbers cruncher like Excel is. Whatever you do in Access has to be done manually! Remember the advantages - but yes, it is very frustrating sometimes.
I would still suggest doing more in a query (your record source), you will find it a lot easier in the long run.