I have this update query that I am trying to run. I know the syntax is
messed up but do not know how to correct it.
Select 'UPDATE', Transactions,'S et [balance] =[Daily Balance] where [Id]=
[Idalias]' From "Get Daily Balances"
Transactions = name of the table I want to update
balance = name of the field i want to update
daily balance= name of the query result that I want to move to the table
(this is the result of a Dsum)
ID=primary key in the table
IDalias = the query resulting copy of the ID number
Get daily balances = the name of the query that I need to update from
Thanks in advance for the help on writng the query correctly
Mark
--
Message posted via AccessMonster.c om
