AnsweredAssumed Answered

calculation field

Question asked by user14360 on Oct 10, 2009
Latest reply on Oct 14, 2009 by user14360


calculation field


Hi.  Is there a way you can have a table that references another table and adds up the values included in all the records in one particular field?


For example, in a sales table, the first field is the company name, and the 2nd field is "week 1", and in that field goes the sales figures for each company.  (Each company is an individual record.)  What calculation do I need to do to add up all of the figures in that "week 1" field?