I have a cashflow table which contains 2 decimal fields both set to default 0.
I also have a Credit/DebitCardExpenses table for card transactions. Once the table closes I run an update routine to dump the sum for the next cardbill into the cashflow table. That all works fine with the exception that the update statement does the update correct but also wipes the o s in unrelated rows ???
This is the code
UPDATE “tblcashflow” SET “debit”= (SELECT “vBillMonthTotals”.“cmytotal”
FROM “vBillMonthTotals” WHERE “vBillMonthTotals”.“cmy” = “tblcashflow”.“cmy” )
Below a before and an after update screendump
Hmm seem to have trouble attaching the images, default to http
Anyway is there a way to stop the code to erase the nulls?