Hi Memrie --
Go to the File menu and select Manage... Database;
Name a new a field sDVDs;
Under the Type sub-menu, select Summary;
In the following Options dialog, leave the radio button at "Total of" and select your DVDs amount field from the Available Fields list;
Click OK to finish the dialog;
Click OK to leave Manage... Database.
You've just created a Summary field called sDVDs (note the lower case s I had you place in the name -- this easily identifies this field as a summary field for you when you're working with it on your layout). This new field will add up the values in your DVDs field (based on found set -- if you are showing all records, all will be added up; if you are showing a found set, only the found set will add up)
Is your layout set to View as List? If so, place your new sDVDs field into the Footer, and when you go into Browse mode, note that the new field now adds up all the values from your DVDs field from the records showing.
Does that help? You can do the above for all your amount fields, and place them all into your Footer, and you will see all the various values added up!
"I have a layout with many fields that keep data separate (money amounts for shirts, DVDs, cost of event, etc...) ... that will add each column (field) and total it at the bottom."
These items should be records and not fields. You then add a Type field (whether DVD, stock, EventCost etc). You then create a sub-summary report grouped by Type. With this structure, one single summary field called sTotalAmount placed in the leading or trailing part (based upon this Type) will produce the proper totals for the found set.