On Sat, 2005-10-29 at 10:48 +0200, G Stansfield wrote: > Greetings! > > I have downloaded OOo_2.0.0_Win32Intel_install.exe & installed on a Win > 2000 Pro machine. I have checked the MD5sum and that is fine. > > I was doing very well converting tables & data from an Access database > and raising queries - till I tried including fields where the Field Type > is set to Yes/No [BOOLEAN]. > > Use "Wizard to create Query", select the required table and those fields > with File Type set to Yes/No [BOOLEAN] are not on the list of Available > Fields. > > Use "Create Query in Design View", select the required table and the > fields with File Type set to Yes/No [BOOLEAN] are available for > selection - but I can't find a criterion that works [Yes, "Yes", 1 don't > work, to list a few I have tried]. > > What am I doing wrong / missing? Something outside OO - like service > pack versions? >
My understanding is that Yes/No are only valid in dBase files and nothing else. What is valid is SQL TRUE and FALSE in most others. All are boolean but ... -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
