Forum Discussion

ThomasRingkamp1's avatar
ThomasRingkamp1
Qrew Member
3 years ago

Distinct Count for Multiple Tasks in Related Table

I have a Project Table and a Tasks Table that are related. I would like to either check a box or count the number of specific tasks that are marked Completed. I tried doing it this way but it doesn't work:
So if 3 Specific Tasks are marked "Complete" (which is a checkbox based on a date field) then I can mark the Cabinet as having been Installed. 
I also tried the beginning of a formula query using just one field and it didn't work either:

Size(GetRecords("{6.EX'Set Cabinet'}and{19.EX'true'}",[_DBID_TASKS]))
Any help would be appreciated

------------------------------
Thomas Ringkamp
------------------------------
No RepliesBe the first to reply