Ok I want to SUM a column and then take that total and put it in another table. I've tried using an UPDATE query with SUM but it doesn't work...
The column holds amounts of money, my query SUM's this column with two conditions; Condidtion one, if the 'paid' column value is TRUE and condition two, if the 'used' column is false (so the same record is not used twice). I want to take the result and enter it into another table named 'balance'. This table may already contain a value so I first want to retrive that value and add it to my total.
As I indicated in your other thread, this is a very VERY bad idea. You are introducing massive probability for normalization issues. You should never store static data that comes from dynamic sources. If you can derive the number you want from information already in the database, you shouldn't be storing it as a static number somewhere else.
I don't get what you mean. I just need to get the SUM of a column and store it in another table to keep track of the balance, nothing will be static. It's for my cousins garage and I can't find answers anywhere. I want to keep everything internal. Is there anyway to access table data from with vba and then insert (update whatever) it into another table withing access?
The data won't be static, eventually job (the table with cost, paid and used in) records will be deleted but there value must stay in the balance table, it accumulates an amount... The used flag will stop the same record being entered twice.