https://communities.sas.com/t5/SAS-Enterprise-Guide/EGuide-Query-Summary-Function-Gotcha/m-p/70762#M7075 Response from designers to tech support: "It's not a bug, it's a feature."<BR /> <BR /> I finally found the behavior documented on page 31-32 of the "SAS/Access 9.2 for Relational Databases, Reference" 4th Ed.<BR /> <BR /> Caveat emptor. Thu, 24 Feb 2011 18:25:56 GMT Doc_Duke 2011-02-24T18:25:56Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EGuide-Query-Summary-Function-Gotcha/m-p/70761#M7074 Just to share a nasty surprise. I was using Query Builder to count the number of visits that had dates present The generated code was<BR /> <BR /> (SUM(t1.SGVisitDate&gt;.)) AS CHEvisitDone<BR /> <BR /> When that code runs against a SAS dataset, all is well. When it runs against an Access table via a LIBNAME (to ACCESS, not to ODBC), it returns all NULLS (no errors or warnings).<BR /> <BR /> If I change the summary function to <BR /> COUNT(t1.SGVisitDate) AS CHEvisitDone<BR /> I get the expected answer with either source.<BR /> <BR /> Caveat emptor! I will also send to tech support. Wed, 09 Feb 2011 18:53:42 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EGuide-Query-Summary-Function-Gotcha/m-p/70761#M7074 Doc_Duke 2011-02-09T18:53:42Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EGuide-Query-Summary-Function-Gotcha/m-p/70762#M7075 Response from designers to tech support: "It's not a bug, it's a feature."<BR /> <BR /> I finally found the behavior documented on page 31-32 of the "SAS/Access 9.2 for Relational Databases, Reference" 4th Ed.<BR /> <BR /> Caveat emptor. Thu, 24 Feb 2011 18:25:56 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EGuide-Query-Summary-Function-Gotcha/m-p/70762#M7075 Doc_Duke 2011-02-24T18:25:56Z