Display summary stats from 2 detail tables in one calculation

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
  • (Edited)
URRGG!  I'm a QB newbie and stuck on some basics.  The app is for a boating club.  I have a table of Members and a table recording the Hours Worked recording the volunteer work each member has completed. Each member promises to complete 20hrs of volunteering.  I'm trying to make a little pie chart that shows the club total number of hours worked and unworked.  To do so, I need a place where I can count the member records and sum the hours worked.  But finding a way to reference both tables seems to be eluding me.

After reading through previous posts, I've gleaned that I might also need a Statistics table, so I've added one of those and made both the Members and Hours Worked tables details of Statistics.  I thought it would be smooth sailing after that but I'm stuck on the shoals of things not working the way I would have guessed they should.  Much appreciate any help.
Photo of Thommango

Thommango

  • 160 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Your "statistics" table that you made might be best considered a "Months" table.  You will want the Month ID (a text field) to be the key field of the table.  Use some unique ID link "Jan 2017", "Feb 2107", etc.

Then you can automatically relate the volunteer hours to the "months"
(look up, formula relationships to get a better feel for how to do this).

Also I'd recommend using a Gauge report to show progress towards a goal, it might be more visual for the progress.