Kaup, Chester
Chester_Kaup at kindermorgan.com
Mon Sep 13 10:27:27 CDT 2010
Tried that with no success. What I just tried that worked was to do a second query using count(*). Maybe not the best solution but it works. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Monday, September 13, 2010 10:04 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Count in a query Perhaps... SELECT dbo_DSS_StatusChanges.Status, Nz(Count(dbo_DSS_StatusChanges.Status),0) AS [Active CO2 Injector Count] FROM [qry Active... Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Monday, September 13, 2010 10:47 AM To: Access Developers discussion and problem solving Subject: [AccessD] Count in a query How can I get this query to return a count of 0 if there are no records returned? SELECT dbo_DSS_StatusChanges.Status, Count(dbo_DSS_StatusChanges.Status) AS [Active CO2 Injector Count] FROM [qry Active Injectors Max Status Date] INNER JOIN dbo_DSS_StatusChanges ON ([qry Active Injectors Max Status Date].MaxOfStatusDate = dbo_DSS_StatusChanges.StatusDate) AND ([qry Active Injectors Max Status Date].Well_Number = dbo_DSS_StatusChanges.Completion_Name) GROUP BY dbo_DSS_StatusChanges.Status HAVING (((dbo_DSS_StatusChanges.Status)="CI")); Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com