AnsweredAssumed Answered

Sub Summary or Aggregates or not possible?

Question asked by JohnColburn on Jun 11, 2013
Latest reply on Jun 27, 2013 by JohnColburn

Title

Sub Summary or Aggregates or not possible?

Post

     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.

     Thanks,

     John

Outcomes