Raised This Month: $ Target: $400
 0% 

Simple SQL (MS Access...) question


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
ddhoward
Veteran Member
Join Date: May 2012
Location: California
Old 05-10-2017 , 05:22   Simple SQL (MS Access...) question
Reply With Quote #1

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.ColumnAIs 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.
__________________

Last edited by ddhoward; 05-10-2017 at 05:23.
ddhoward is offline
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 01:13.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode