This code is throwing back an "Invalid procedure call" error message:
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?
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?