You can use a summation (totals) query to do this. You would "group by" on all the fields except TotalSpent, for which you would use "Sum".
But what do you mean by "in design view" - in design view of what? Regardless, the answer to your question is No, you can't get a total in design view.
You also need to rethink your data structure - it is not properly normalized. Was it imported from Excel?