Lets say I have 2 fields in a table, Score1 and Score2. I would like to calculate the sum of the scores and save it in the 3rd field called TOTAL.
I'm using MS Access 2007 and was wondering how to do this without SQL or VBA.
I was able to create a query that does this successfully, but i'm not...