I believe I am getting 'syntax error in SQL statement' type of error messages because some of the rows in a numeric column in an Access database have zero and others are blank, leading me to believe they are NULL.
Is there a way to test for a null value in a numeric field? Thanks In Advance, Ed Gordon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

