[AccessD] Count query

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Wed Feb 25 09:35:31 CST 2004


Good Mornig Group.

Is it possible for one query to count how many records are up to 150 days
old and have been chechked and the ones that haven't ? I understand how to
do in 2 queris, i am wondering if its possible to do in one

thanks,
Oleg

SELECT Count([Ron Data mid AP].ID) AS CountOfID
FROM [Ron Data mid AP]
WHERE (((Date()-[Ron Data mid AP].[MS Date Opened])<149))AND (([Ron Data
mid AP].FileToSupervisor) Is not Null));

SELECT Count([Ron Data mid AP].ID) AS CountOfID
FROM [Ron Data mid AP]
WHERE (((Date()-[Ron Data mid AP].[MS Date Opened])<149))AND (([Ron Data
mid AP].FileToSupervisor) Is Null));




-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail





More information about the AccessD mailing list