Field calculating total of unrelated records

[Becky0124]

I have two files Company and employees .Employees are related to comapanies by a lookup code. In employees I need to create a field that totals all employees that meet a certain criteria. I am having no luck. Is this possible?

[-Queue-]

Create a calculation number field in your Employees file that equals your criteria test, e.g. Type = "part time". Then in your Company file, create a calculation of Sum(Employees::calcfield). This will give you a total of all related employees where the calcfield equals 1, i.e. the test returns true.