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