How do I setup a sum field

[Jaser247]

Hope someone can help. Let's say I want to create a database that has all my employees. In that database I want a couple fields named.. Total Employees and Total Engineers ect....How do I do these total field? I think I need to do some sort of calculation for that field but I have no clue on where to start.

Thanks,

Jaser

[Fitch]

If you just need this in a report, use Summary fields, which you would then place on a Subsummary part that is sorted by type of employee, and the same field on a Trailing Grand Summary would give the total of all employees.

However, if you need to see these numbers in Browse mode, e.g. on a data entry screen, it's a little more complicated: you'll need a "constant" field, i.e. a calculation that is simply the number 1. Let's call it One. Then, for each type of employee, a calc like this: (employeeType = "Engineer"), which will return 1 if true. Let's call this field ETEngineer. Now you need a relationship for each employeeType calc, e.g. One::ETEngineer. We'll call this ETEngineerRel. Lastly, a calc like this:

Sum (ETEngineerRel::ETEngineer)