Darren DICK
d.dick at uws.edu.au
Mon Nov 29 21:59:36 CST 2004
The math fails on a null usually. So just turn nulls to zeros - it is a valid way of doing it Convert a null to zero then the math will work Eg In a query some thing like xLINETOTAL:iif(isnull([UnitPrice]),0) Or nz([UnitPrice],0) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Tuesday, 30 November 2004 1:07 PM To: 'Access Developers discussion and problem solving'; 'ACCESS-L' Subject: [AccessD] Calc line total if unit price is null X Posted Clients that like incomplete data make me nuts. Building A PODetails report. Client has prices for some things but not others. They fluctuate day to day. I can calculate quantity*price I need a workaround for 1. Line Total 2. PO Total When some or all prices on a Product are null. Sitting here tapping my receive key Thanks gang. JOE HECHT LOS ANGELES CA jmhla at earthlink.net -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com