scouser
Registered User.
- Local time
- Today, 09:31
- Joined
- Nov 25, 2003
- Messages
- 767
Hi to all. A query is returning #Div/0!.
The sum is as follows:
Line Total = 0
CostPrice = 3.32
I thought the addition of Nz would resolve this but maybe I am adding incorrectly.
Thansks,
Phil.
The sum is as follows:
Line Total = 0
CostPrice = 3.32
I thought the addition of Nz would resolve this but maybe I am adding incorrectly.
Code:
Margin: Nz([tblSalesOrderDetails].[LineTotal]-[tblSalesOrderDetails.CostPrice],0)/[tblSalesOrderDetails].[LineTotal]
Phil.