Forum Discussion
MS Access MID-Function automatic change "," into "."
I have some issue with my queries in MS Access version Microsoft Access for Microsoft 365 MSO (16.0.14326.21052) 64-bit When create a query using Mid-function, Mid([RCV_RECEIVD_REC],3,3) MS ...
What is your computer decimal separator. Is it comma (,) or dot (.)? Based on regional settings you may need to use semicolon (;) instead of comma (,). Can you please share a small sample file with the issue?