Hi, I have a database set up with multiple tables.
Set up like this
Person1 (Information in one table) gets 5 Linked Entries in another table
How can I get these linked records to sum in the table with the first table
Summing From Tables
Hi there!
Not sure what you’re trying to sum up, but…
If you only want to count how many linked records there are for a particular person, you can use the Count field type. Otherwise, you’ll likely want to use a Rollup field.
Add a field on the first table, point it at the field on the second table that you want to sum up, then use the formula:
SUM(values)
Hope that helps!
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.