I have an Access database that generally functioned correctly up until a couple of weeks ago. Randomly it started deleting the SQL in the query and replaced it with "select;". This happens sometimes after running the query and other times after a couple of days.
I have checked before running the query and the code is there, it runs properly, after completing it goes away. There is also nothing in design view when its gone. Any ideas? Here is the query below.
SELECT CERT_BATCH_PRINT_FILE.BUSINESS, CERT_BATCH_PRINT_FILE.[LAST NAME], CERT_BATCH_PRINT_FILE.[FIRST NAME], CERT_BATCH_PRINT_FILE.EMAIL, [SHORT TITLE] & IIf([TYPE]="COMP"," - Completion",IIf([TYPE]="CERT"," - Certification","ERROR")) AS CERTIFICATE, CERT_BATCH_PRINT_FILE.[CERT NUMBER], CERT_BATCH_PRINT_FILE.[EXP DATE], CERT_BATCH_PRINT_FILE.NOTES, CERT_BATCH_PRINT_FILE.[PRINT FLAG]
FROM CERT_BATCH_PRINT_FILE
ORDER BY CERT_BATCH_PRINT_FILE.BUSINESS, CERT_BATCH_PRINT_FILE.[LAST NAME], CERT_BATCH_PRINT_FILE.[FIRST NAME];
Thanks for your help.
You need to sign in to view this answers
