Hi Paul, I would remove >> >>> "Ions-IM"."Select" = TRUE
and >>> "Equipment"."Series" = 134 and try the query again. Both commands are right in the internal Firebird-Database. I could test it with with LO 6.1.4.2 here. But could be there is something wrong with the fields ... Is there another Boolean field part of the query? You could also send me the database with some dummy-data as private mail, so I could have a look. Would be good to see the reason for writing a bug and describe it in Base Handbook. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
