Search results

HEY, HEY...Thanks!! I've been Googling this all morning and the only resolution I could find was to break out the Sub Queries into seperate ones. Not exactly what I wanted to do. You're a lifesaver!!

Hi Bob, Thanks for the advice. It still replaces the code when I close and reopen to the SQL below, but at least it runs with this change and no error message. You're a genius!! SELECT COUNT([EMP_ID]) FROM [SELECT DISTINCT [EMP_ID] FROM tbl4thQuarter_Trimmed WHERE ([BF_Risk]='Average')]. AS...

Hi, I have a query I wrote that looks like the 1st SQL below. I run it and it works fine. I save it, close it and reopen it and it looks like the 2nd SQL below. At this point I have to change it back to the 1st SQL to run or I get an an error like the screen shot attached. Any idea what's...