Access has a yes/no type that you can use as a Boolean-esque field. Checking for Yes/No and I think you can check for existence as the yes as well. Not sure on the last part. Hope that helps. J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer www.red-omega.com <http://www.red-omega.com> "Losing - If at first you don't succeed, failure may be your style." ~despair.com -----Original Message----- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 12:49 PM To: CF-Talk Subject: How do I create Boolean field with create table in access? How do I create Boolean field with create table in access? what other field types are available? Thanks mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
