iattlakerod
Registered User.
- Local time
- Today, 16:30
- Joined
- Jan 12, 2003
- Messages
- 12
Another "Null" Question
The answer to my question seems to me to be quit simple. However I continue to struggle with this Null value issue. I've created a query based upon a Parts table that is divided into "Parts", "Labor", and "Tires". I run a query to determine the costs by P, L, or T. I currently have recorded costs for Parts and Labor however no cost exist for Tires. When I run the query, because the Tire value is null, no results for any item is displayed.
Using the Field- [Repair Location] = OTR
Using the Field- [PLT] where = T
Using the Field- OTR Tire Cost: Sum(nz(CCur([RepairOrderDetails].[partcost]))*(nz(CCur(([RepairOrderDetails].[quantity])))))
Now this example is for the query for Tires only. Still shows not data, not even a "0".
The answer to my question seems to me to be quit simple. However I continue to struggle with this Null value issue. I've created a query based upon a Parts table that is divided into "Parts", "Labor", and "Tires". I run a query to determine the costs by P, L, or T. I currently have recorded costs for Parts and Labor however no cost exist for Tires. When I run the query, because the Tire value is null, no results for any item is displayed.
Using the Field- [Repair Location] = OTR
Using the Field- [PLT] where = T
Using the Field- OTR Tire Cost: Sum(nz(CCur([RepairOrderDetails].[partcost]))*(nz(CCur(([RepairOrderDetails].[quantity])))))
Now this example is for the query for Tires only. Still shows not data, not even a "0".
