Hello,
I have 2 tables :
source_table : this one is an ACCESS table containing my ID and my value
target_table : this one is a SharePoint table import by linking under ACCESS containing my ID and my value
My SQL/ACCESS query is :
UPDATE source_table, target_table SET target_table.Value = Format(source_table.Value,"Percent")
WHERE (target_table.ID = source_table.ID);
I get the following error message in french :
I try to modify the format from my source_table to adapt to the taget_table format and I try to drop in SET clause the format function, but I have an another error message in french :
If you can ever help me it would be great! Otherwise I know that I can go across these error messages via VBA but I would prefer to stay on SQL queries.
Thank you in advance for what you can do to help me.