What are your tables? Why you don’t have all the payments in the same table?
What are your tables? Why you don’t have all the payments in the same table?
Elias,
I have the tables separated by areas of expense (building material, staff, food…etc) some expenses were paid in cash and others in credit card. I would like to sum the amounts paid in cash from all tables in a “Summary” table.
Thanks for your help!
Elias,
I have the tables separated by areas of expense (building material, staff, food…etc) some expenses were paid in cash and others in credit card. I would like to sum the amounts paid in cash from all tables in a “Summary” table.
Thanks for your help!
I’d recommend you to merge those tables into an unique Expenses table, with a single select field for Area, as you’ve made with Payment Method. Then you will know very easy the amount by Method, Area, or any other field, by using the Grouping feature.