ContributionsMost RecentMost LikesSolutionsRe: Using summary totals in another reportPerfect. Worked like a charm. that opens up so many other options for me also. Thanks so much Mark! ------------------------------ Joe Blouin ------------------------------ Re: Using summary totals in another reportTracking attendance in 'Attendance' table. (child of 'Associates' table) different types of absences cost different amount of "points" 1/2 NF = .5 1 NF=1 NCNS = 3.5 I built a summary table that totals the different types of absences and gets me a total points per Associate. My challenge is that Each Associate started with a different Allowable NF amount... For instance Associate A is allowed 7 and Associate B is allowed 5. The number allowed per Associate is stored in the parent table 'Associates' per each Associate. I would like the calculate the remaining points... If Associate A started with 7 allowed but has accumulated 4 points in absences, then the remaining would be 3 points. ------------------------------ Joe Blouin ------------------------------ Using summary totals in another reportHi, I added the values of a field in a summary table. Now I need to compare that summarized total number to another number in another table... How do I make a report and do this formula? Thanks. ------------------------------ Joe Blouin ------------------------------ Using summary totals in another reportHi, I added the values of a field in a summary table. Now I need to compare that summarized total number to another number in another table... How do I make a report and do this formula? Thanks. ------------------------------ Joe Blouin ------------------------------