I'm using Access to develop a demo site and I'm trying to pull the records which have a date/time field which is not filed in. I tried to say WHERE fieldname = NULL, but that doesn't seem to do the trick. Is there a keyword that I can use instead of NULL to get the same result or do I have to add a flag to see that the record has been updated?
John Kivus 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