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?