[AccessD] Count query

Gustav Brock gustav at cactus.dk
Wed Feb 25 11:02:48 CST 2004


Hi Oleg

Ahh, got it now, omit the ID:

SELECT
  Sum(Abs(Not IsNull(FileToSupervisor))) AS CheckedID,
  Sum(Abs(IsNull(FileToSupervisor))) AS NotCheckedID
FROM
  [Ron Data mid AP]
WHERE
  (Date() - [MS Date Opened] < 149);

/gustav


> hey Ryan, yeah this one calcualates correctly -- 4 done, 480 to go,
> the one below gave 321017 and 25515793...
> (they wish they had that many cases) :--)

> SELECT
>   Sum(ID * Abs(Not IsNull(FileToSupervisor))) AS CheckedID,
>   Sum(ID * Abs(IsNull(FileToSupervisor))) AS NotCheckedID
> FROM
>   [Ron Data mid AP]
> WHERE
>   (Date() - [MS Date Opened] < 149);




More information about the AccessD mailing list