AnsweredAssumed Answered

Combining Data from two different tables in one subsummary report

Question asked by canciod on Dec 30, 2009
Latest reply on Dec 30, 2009 by philmodjunk

Title

Combining Data from two different tables in one subsummary report

Post

I have been attempting to create a "profit and loss" type of report in a data base I created for a school food services program.  I have one data base with several tables, one for income earned through meals served and one for labor costs (still need to add a table for food costs, but that will come later).  I cannot seem to combine summary reports (by month and location) that display both the revenue and the labor costs.  I have created table occurances for the labor cost and participation and have joined them.  I thought that would do it but it has not. I can get the revenue information to report perfectly, but cannot bring over the labor cost information.  Any advice would be very much appreciated.

Outcomes