Forum Discussion

ThommangoThomma's avatar
ThommangoThomma
Qrew Trainee
8 years ago

Display summary stats from 2 detail tables in one calculation

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 complet...
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
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.