Re: SQL - INSERT INTO booleans

Tim Burgan wrote: > I am continually getting a data type mismatch error (relating to the > boolean columns) when trying to execute this code. > > I've tried removing the single quotes, but that returns a syntax error. I've forgotten the rules for MS-Access, but... Perhaps try 1 and 0 as your bool, with no apostprophes. I really would have expected the true/false with no apostrophes to work myself... You could try to build a sample query in Access itself, using that damn GUI thingie they have, which always just confused me personally, to see what Microsoft thinks is proper SQL -- Not that it really *IS* proper SQL, but at least it will work with Access, hopefully. -- Like Music? http://l-i-e.com/artists.htm