Updating records

[eacollie]

I need to update a table row based on a summation of rows in another table (a mixture of numbers, text, y/n, and date fields).

Any suggestions would be greatly appreciated!

Thanks

 

[jdraw]

Sounds like you might be storing calculated values - this is not a recommended practice.
If you need calculated values, create a query for same.
Are there some extreme circumstances involved that make the query not an option?