Link to home
Start Free TrialLog in
Avatar of keschuster
keschuster

asked on

SharePoint Moss & MS Access - Query with Grouping not working

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
Avatar of rbeadie
rbeadie
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of keschuster
keschuster

ASKER

YOU DA MAN!  Thanks