Calculated Field SUM all records
Excuse me if this seems like a very simple and stupid question. I've looked through the documentation and read through the forums but can't figure out how to do this simple task. I have a database set up that only has 6 fields. I would like one of those fields to have a calculated amount that is the sum of one field from all of the records. Currently I am using SUM (NameofField) however, it will only give me the value for the selected record and not all records in the file.