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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER