Hello,
I am trying to add up fields on if certain criteria are met. User uses a drop down list for Expenses Category for the daily balance sheet using a form. At the end of the week I am having to add up every field that corresponds to: Labor, Entertainment, Repairs, Etc. So each day can have all or none of these expenses. Is there a way to show just labor for the whole week, and zeros for anything else on a daily or weekly basis? And also Entertainment, Repairs, and so on? Thanks in advance.
Here is what the table looks like:
Day Misc1 Misc1Cat Misc2 Misc2Cat Misc3 Misc3Cat Wednesday, January 01, 2014 $14.00 Re-Deliveries $45.00 Labor $30.00 Hardware Thursday, January 02, 2014 $30.00 Labor $100.00 Misc $4.00 Re-Deliveries Friday, January 03, 2014 $25.00 Labor $11.00 Misc $20.00 Misc Saturday, January 04, 2014 $35.00 Labor $1,075.00 Labor $60.00 Vehicle Expense Sunday, January 05, 2014 $40.00 Labor $600.00 Hardware $4.00 Re-Deliveries Monday, January 06, 2014 $35.00 Labor $16.00 Re-Deliveries $168.00 Food Purchases Tuesday, January 07, 2014 $30.00 Hardware $20.00 Labor $8.00 Re-Deliveries Wednesday, January 08, 2014 $55.00 Labor $16.00 Re-Deliveries $75.06 Checks Thursday, January 09, 2014 $60.00 Vehicle Expense $8.00 Re-Deliveries $28.00 Food Purchases Friday, January 10, 2014 $20.00 Misc $25.00 Labor $70.00 Repairs Saturday, January 11, 2014 $68.00 Food Purchases $88.00 Food Purchases $45.00 Vehicle Expense Sunday, January 12, 2014 $2,000.00 Misc $30.00 Hardware $20.00 Labor Monday, January 13, 2014 $14.00 Hardware $166.00 Misc $25.00 Labor Tuesday, January 14, 2014 $10.00 Re-Deliveries $25.00 Labor $10.00 Food Purchases Wednesday, January 15, 2014 $13.00 Refund $7.00 Re-Deliveries $30.00 Labor Thursday, January 16, 2014 $40.00 Labor $8.00 Re-Deliveries $100.00 Flyer Distribution Friday, January 17, 2014 $65.00 Gas $19.00 Re-Deliveries $94.60 Checks Saturday, January 18, 2014 $20.00 Re-Deliveries $7.00 Re-Deliveries $30.00 Labor Sunday, January 19, 2014 $20.00 Labor $0.00
$0.00
Monday, January 20, 2014 $25.00 Labor $85.00 Labor $17.00 Hardware