It's called a Yes/No field in Access. Access will take either 1/0 or True/False values. Use 1/0 to maintain compatibility with MS SQL Server. Internally, I think it's stored at 0 and -1, go figure. > 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
