i got this error when i copy the sql from the thread given. Is anything that I need to pay attention to? thanks E-16053 : SQL Statement is empty or invalid.
I tried to copy and paste the SQL from the thread and I got a lot invalid characters. I think that's the cause of the error. So, I saved the SQL in a Word doc. Pls try again. 瀏覽附件staff_leave.zip
thanks for help at the beginning I also deleted the invalid characters but i got the error msg. but now i still got the same error when I used the code from the word file.
I tried the SQL again and i was able to extract the data. Pls contact your school liaison officer. I need more info for investigation.