invalid use of null?

[dm1]

Hi folks, I'm getting an inavalid use of null error when i run a query of:

SELECT DISTINCTROW Orders.CustomerID, Orders.OrderDate, Orders.FreightCharge, Orders.SalesTaxRate, Sum(CLng([Quantity]*[UnitPrice]*(1-[Discount])*100)/100) AS [Total Sales], Sum([Order Details].Quantity) AS [Total Units]
FROM Orders LEFT JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID
WHERE (((Orders.OrderType)="1&quot)
GROUP BY Orders.CustomerID, Orders.OrderDate, Orders.FreightCharge, Orders.SalesTaxRate;

Can anyone see where I'm going wrong?

Cheers, Jon. [sig][/sig]

 

[WP]

Jon,

One of your fields in a calcuation is null. Check the data of all numeric fields.


[sig]<p>Bill Paton<br><a href=mailto:william.paton@ubsw.com>william.paton@ubsw.com</a><br><a href=

http://www.neptune400.co.uk/>http://www.neptune400.co.uk/</a><br>

Check out my website ![/sig]

 

[Scoty]

You may want to bracket all your fields with iif(isnull(YOUR_VALUE),0,YOUR_VALUE) this will give you the freedom to leave a field null...I would also suggest making the default value of your fields to 0 (zero) and running an update querry.

 

[dm1]

Thanks guys, it was a null field I'd overlooked and have set it as required before form can be closed now.

Cheers, Jon