My Assistant
|
|
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. |
|
|
|
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![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 25th May 2013 - 09:33 AM |