I made this SQL to pick up one value from the top row of file.
How cab I convert this on value result of this SQL to UPDATE one field in another field in a Table which has only one Record.
The field in the second table to be updated , say AAA in table ABCD.
SELECT TOP 1 [TimeRange].BankBal
The above select is picking the correct value that I need.
Optionally, Can I send the value of this SQL into a bound object (or even unbound) in an open form?