Hi,
New to this forum here so forgive me if this has been posted or if i am posting this in the wrong place. I am not a huge access wizard but i am using it quite often. one of my databases which i made and have been using for two years now suddenly gave me wrong results. I was investigating and came to the conclusion that a MID function which i use in a query did not work properly anymore. I made a new DB with just this a mid function in a query and it did not give the (in my opinion) right results, where it did work before.
Here is the problem:
I have this formula in a query:
test: mid("hellohello", 4, 2)
Result should be “lo”. Starting on the 4th character and returning the next 2. However the result is “lohello”. So it just returns all characters after the 4th. Also what I noticed now is that when I put a space between the comma and the 4 it gives an error saying:
The expression you entered contains an invalid syntax
You may have entered an operand without an operator
Any thoughts on what causes this?
Thanks!