Hello All,
I'm trying to update a blank column in another table that is linked to sharepoint. I'm updating that table with names from a another table. I keep getting blank rows indiciting that the query isn't working can you please assist? Please see below:
UPDATE [Historical Daily Hours JD] INNER JOIN [Historical Daily Hours] ON [Historical Daily Hours JD].Name = [Historical Daily Hours].Name SET [Historical Daily Hours JD].Name = [Historical Daily Hours].[Name]
WHERE ((([Historical Daily Hours JD].Date) Between "6/1/2021" And "9/30/2022"));
I'm trying to update a blank column in another table that is linked to sharepoint. I'm updating that table with names from a another table. I keep getting blank rows indiciting that the query isn't working can you please assist? Please see below:
UPDATE [Historical Daily Hours JD] INNER JOIN [Historical Daily Hours] ON [Historical Daily Hours JD].Name = [Historical Daily Hours].Name SET [Historical Daily Hours JD].Name = [Historical Daily Hours].[Name]
WHERE ((([Historical Daily Hours JD].Date) Between "6/1/2021" And "9/30/2022"));