PDA

View Full Version : Co-Worker Named a query "NULL_REPORTS"



KSReynolds
07-07-2014, 12:54 PM
Access 2010. I have a co-worker name a query "null_reports" Now when I try to design a query and type in "is null" in the criteria, access changes it to " is [null_reports] " and I have to play games to take out the bad syntax. What other problems could this create? I have googled and apparently no other person has ever pulled such a stunt. I have to convince my management that this is outright wrong.

ranman256
07-08-2014, 09:08 AM
Odd. Try only typing NULL. It should correct it to IS NULL.