title: How To Calculate Columns Selectively in MS Access
body: <p>I am creating a Travel Expense Report using Microsoft Access 2007. I am new in creating this. I already created tables and forms in MS Access. I have a meal, transportation, and other allowances in my table. The user of the application will enter his/her expenses for the whole week in the table. I already figured out on how to get the total of each expenses in rows. My problem is how could I get the total of each allowances like the total of all meal, total of all transportation, and total of all other expenses for the entire week..</p>