Post your code. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com
-----Original Message----- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:53 PM To: CF-Talk Subject: MS-Access: nulls in numerics? 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/cf-talk@houseoffusion.com/ ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists