JOIN query with SUM function

[BigMikeM]

Hi guys n girls,

Some background. I have multiple stores which people deposit money to. One store can have multiple deposits on the same day. I am using a StoreDate combo as a 'unique' key and a join value.
I have built a query that joins two tables but I am only getting one value - i need to sum all the values by the StoreDate.

Tbl_SB_Daily_ShiftTotals has a unique list of the StoreDate eg StoreX01/01/2015 (you will only see this once in this table)
tbl_MPESA_Deposits has multiple records of deposit amounts per store per day eg StoreX01/01/2015 (this you may find as many times as people have deposited)



Now i need to join these two tables so that the SUM of StoreX01/01/2015 (from tbl_MPESA_Deposits) is found in the single record StoreX01/01/2015 in tbl_SB_Daily_ShiftTotals

The standard join which only brings back one value is as follows;
As far as i know i need a select statement in here which i did and all i get it a Error: Operation must use an updateable query

UPDATE
tbl_SB_Daily_ShiftTotals
INNER JOIN
tbl_MPESA_Deposits ON tbl_SB_Daily_ShiftTotals.StoreDateJOIN = tbl_MPESA_Deposits.StoreDateJoin
SET
tbl_SB_Daily_ShiftTotals.MPESADeposit = [tbl_MPESA_Deposits].[PaidIn]
WHERE
tbl_SB_Daily_ShiftTotals.MPESADeposit Is Null
AND tbl_MPESA_Deposits.DepositFor Like "SB";


Any help will be appreciated.
Thanks
Mike

[June7]

LIKE operator without wildcard is useless, might as well just be = sign.

LIKE "*SB*"