People here know SQL, right? Right?
Alright, so I'm simply trying to update all null entries in ColumnA of TableA with the largest value found in ColumnB of TableB.
What do.
This is what Access auto-generates.
PHP Code:
UPDATE TableA SET TableA.ColumnA = Max([TableB].[ColumnB])
WHERE (((TableA.ColumnA) Is Null));
Quote:
|
Your query does not include the specified expression 'ColumnA' as part of an aggregate function.
|
I honestly have no idea what I'm doing but this is the finishing touch on a project due tomorrow.