Sub Summary or Aggregates or not possible?
I have been attempting this for the past three days. I have looked at numerous posts as well as a couple training videos, so it's not that I'm lazy, I'm just a little dense.
To simplifiy as much as possible: I have two tables: Trips & Expenses.
Trips table has these fields: Trip_ID, Trip_Name, Start_date, & End_date
Expenses table has these fields: Trip_ID, Category, Date, Amount, Total_amount(summary field)
I would like to have a layout that shows just one Trip and has totals for each category. Example: Trip_ID is 1001. There are, in addition to other categories, two "Airfare" categories. One for $150 and the other for $200. I would like one of the rows to just show the total of $350. the rest of the rows would be populated with totals of the other categories that have a Total_amount greater than $0.