Sum of table against another

[papasmurfuo9]

Hi

i have two tables,

one list contract numbers as a unique number, and fields assoicated with that contract


then another table, list the same contract numbers, with sales by that contract number each day,

so
Contract sales Date
225 1 01/09/2014
225 4 02/09/2014
225 2 03/09/2014
225 2 04/09/2014

how do i add the second tables total sale number, to the contract on there?


i have a query with both tables, listing what i need from table 1, table 2 i need the totals of sales per contract

thanks in advance

 

[papasmurfuo9]

anybody, thank you.

 

[JHB]

If you link the 2 tables together by contract numbers, can't you run a sum query? Click the Sigma sign in the menu tools line.