SQL Update Table Finding the Correct items to update but not Updat

  • Thread starter Thread starter sfleck
  • Start date Start date
S

sfleck

In access 2007 the following query is finding the correct Items to update but
is not updating the Table

UPDATE 8500_2 LEFT JOIN Findings ON [8500_2].[Control Number] = Findings.[IA
CONTROL] SET [8500_2].Description = [Findings]![Description of Finding]
WHERE ((([8500_2]![Control Number])=[Findings]![IA CONTROL]));
 
Are you executing the query or just switching the view? If you just
switch the view, the query will show you the records that WILL be
updated, but it will not update the values.

In earlier versions of Access there is a Run Query button. I suspect
that it is available somewhere on the ribbon in 2007.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top