Access Query / SQL problem

Associate
Joined
18 Dec 2002
Posts
1,542
Location
Cardiff
This code is throwing back an "Invalid procedure call" error message:
Code:
SELECT Count(CPLSHARE.[File Name]) AS Files, Sum(CPLSHARE.[Size (Kb)]) AS [Total Size (Kb)], Left(Right([Directory],Len([Directory])-46),InStr(1,Right([Directory],Len([Directory])-46),"\")) AS [Basic 2]
FROM CPLSHARE
WHERE (((CPLSHARE.Parent) Like "out*"))
GROUP BY Left(Right([Directory],Len([Directory])-46),InStr(1,Right([Directory],Len([Directory])-46),"\"));

Yet if (CPLSHARE.Parent) Like "out*")) is set to Like "Change*" it works and returns the names of the top sub folders within this folder and their size/count of files within.

Anybody?
 
Back
Top Bottom