0
Total of a field in all records.
No experience with databases but I managed to get a simple one running to track my stock of radio vacuum tubes. Each record has a numeric field titled "how many" where I enter how many of each tube I have.
Id like to add a field titled "total" that sums up all the "how many" fields in each record to tell me the total number of tubes I have overall.
ive worked on this until it's obvious I'm not making any headway. Thanks for any help.
3 replies
-
If you click on the column header of "how many", you'll get a popup with some options. Choose "Sum" and the total will be displayed at the bottom of that column.
-
You can create a 'Formula' field with this code:
sum((select TableName).YourField)
Nick
-
Thank you, that works.
Content aside
- 5 yrs agoLast active
- 3Replies
- 1346Views