Paul Hartland (ISHARP)
paul.hartland at isharp.co.uk
Tue Nov 30 10:00:12 CST 2004
What about ExtraColumn1: IIF([ClientHours]<>0, [BOOK]) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of oleg_123 at xuppa.com Sent: 30 November 2004 16:52 To: accessd at databaseadvisors.com Subject: [AccessD] Query Question I need a query to have 4 extra columns, which would have values from column [book] is previous column is not 0. something like ExtraColumn:IF [clienthours] <> 0 Then [book] Thank you ----------------------------------------- You are entitled to Get 100% FREE perfume (S&H is FREE)! Click Here: http://azjmp.com/az/ch.php?f=176&i=657&sub=webmail -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com