Default value return
- From: Dragon <Dragon@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 20 Jan 2009 14:09:01 -0800
I have a query that counts my trailers loaded in a given day for a given
warehouse. I have the data broken down by types (ie, export, truck, can) and
in a particular order.
The problem is: I need the query to return a default value of 0 for each
possiblity when there is no trailers of a particular type loaded in the given
day. (SQL below)
ie: if there were 3 non export, no export trucks and 2 export cans I need an
output of:
Non export: 3
Export Trucks: 0
Export Cans: 2
Thanks,
Dragon
SQL:
SELECT [PCS / Bulk Ship].Warehouse, [PCS / Bulk Ship].ShipDate, [PCS / Bulk
Ship].Export, [PCS / Bulk Ship].Can, Count([PCS / Bulk Ship].[Unit #]) AS
[CountOfUnit #]
FROM [PCS / Bulk Ship]
WHERE ((([PCS / Bulk Ship].[Unit #])>"0.1") AND (([PCS / Bulk Ship].Rail)=0))
GROUP BY [PCS / Bulk Ship].Warehouse, [PCS / Bulk Ship].ShipDate, [PCS /
Bulk Ship].Export, [PCS / Bulk Ship].Can
HAVING ((([PCS / Bulk Ship].Warehouse)='Bulk') AND (([PCS / Bulk
Ship].ShipDate)=[What is the date]))
ORDER BY [PCS / Bulk Ship].Export DESC , [PCS / Bulk Ship].Can DESC;
.
- Follow-Ups:
- Re: Default value return
- From: pietlinden@xxxxxxxxxxx
- Re: Default value return
- Prev by Date: Macros / Scripts in Word and Excel
- Next by Date: query with dates
- Previous by thread: Macros / Scripts in Word and Excel
- Next by thread: Re: Default value return
- Index(es):
Relevant Pages
|
