AndrewInCornwall
New member
- Local time
- Today, 07:44
- Joined
- Feb 8, 2022
- Messages
- 3
After a hard disc failure I've been forced to upgrade from running Access 2013 on Windows 7 to Office 365 on Windows 10
An upgrade query that worked fine before (for many years) would replace spaces with dashes.
The Update To contained:
Replace([Stock]![stkItemURL]," ","-")
But now, with the new version, if I try to run this query I get a type conversion error, and if I still chose to run the query it just removes all data from that field.
I'm hoping someone has a solution for me that doesn't involve vba as I haven't a clue about that (I do everything with queries)
Andrew
An upgrade query that worked fine before (for many years) would replace spaces with dashes.
The Update To contained:
Replace([Stock]![stkItemURL]," ","-")
But now, with the new version, if I try to run this query I get a type conversion error, and if I still chose to run the query it just removes all data from that field.
I'm hoping someone has a solution for me that doesn't involve vba as I haven't a clue about that (I do everything with queries)
Andrew