Combining Data from two different tables in one subsummary report
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.