UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Count in Query    
 
   
DAPPayroll
post Feb 9 2007, 07:18 PM
Post #1

New Member
Posts: 19



I want the query to display a 0 if the count is 0. Currently, it displays nothing. How do I fix this?

Here is an example of my SQL:

SELECT Count([ExtendedPrice]) AS [CountOfExtendedPrice] FROM [Order Details Extended] GroupBy [ExtendedPrice] HAVING ((([ExtendedPrice])="100.00"));

So it counts how many times it finds extended price being 100.00

If there are no 100.00's, I want it to say 0 but it currently says nothing at all.

Any help would be greatly appreciated, thanks.
Go to the top of the page
 
+

Posts in this topic
- DAPPayroll   Count in Query   Feb 9 2007, 07:18 PM
- - DAPPayroll   Re: Count in Query   Feb 9 2007, 07:31 PM
- - GroverParkGeorge   Re: Count in Query   Feb 9 2007, 07:34 PM
- - DAPPayroll   Re: Count in Query   Feb 9 2007, 07:43 PM
- - rabroersma   Re: Count in Query   Feb 9 2007, 07:47 PM
- - DAPPayroll   Re: Count in Query   Feb 9 2007, 07:51 PM
- - rabroersma   Re: Count in Query   Feb 9 2007, 07:59 PM
- - DAPPayroll   Re: Count in Query   Feb 9 2007, 08:03 PM
- - DAPPayroll   Re: Count in Query   Feb 9 2007, 08:14 PM
- - rabroersma   Re: Count in Query   Feb 9 2007, 08:16 PM
- - rabroersma   Re: Count in Query   Feb 9 2007, 08:17 PM


Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 09:33 AM