troubleshooting Question

SharePoint Moss & MS Access - Query with Grouping not working

Avatar of keschuster
keschuster asked on
Microsoft AccessMicrosoft SharePoint
2 Comments1 Solution450 ViewsLast Modified:
I've got a sharepoint list linked to and access 2007 database.  I'm trying to get a grouped count with this query

SELECT [Client Data Loaders].COE, Count([Client Data Loaders].[CS Doc Complete]) AS [CountOfCS Doc Complete]
FROM [Client Data Loaders]
GROUP BY [Client Data Loaders].COE
HAVING (((Count([Client Data Loaders].[CS Doc Complete])) Not In (0)));

This returns nothing.  The field CS Doc Complete is a Yes/No field.
If I just pull up the table and filter CS Doc Complete = Yes - then look in Advanced Filter I get the Not In (0).  Now I would think using this in a query would return a count of records where CS Doc Complete = yes grouped by COE.

Any ideas?  Is there a trick to this when linked to SharePoint?
ASKER CERTIFIED SOLUTION
rbeadie

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros