thanks for replying.
I’m unsure about all your solutions. I try to be a bit more precise with another example. Here’s my situation with two tables:
- Tools - contains tools
- Job Log - contains jobs while for each job one tool is used. Also contains the time the job takes
What I now want is to sum up the time that each tool was used in jobs and display it right within the record on the Tools table.
As I understand the rollup field doesn’t have that filter where I can only select the entries where the tool is used but can rollup everything from the Job log table. Is that right? Also the Rollup doesn’t seem to able to add up values that were created by DATETIME_DIFF.
Grouping is nice but isn’t exactly what I want as well as a filtered view.