asadj04

Thanks that worked. I created the calculation field as above. What if i wanted to find out the total number of 'High' priority tasks across all 'Projects'. For example: project 1 has 3 high priority tasks project 2 has 1 high priority tasks project 3 has 2 high priority tasks So there are total 6 high priority tasks.

I have a table named 'Projects' and a table named 'Tasks'. Each task is related to a certain project. Each task is assigned a priority in the 'priority' field in the 'tasks' table, it can have one of three values which are 'high', 'medium' or 'low'. 1. I want to find how many tasks are assigned a priority of high for example. 2. Then i want to display this data on another layout, so it will say something like 'There are 3 tasks with a high priority'