Le 17/07/11 13:08, Ian Whitfield a écrit : Hi Ian,
> > When making a Query in LO Base how do you select the contents of a > Tick-Box? > > ie I have a Tick-Box to indicate a particular class of people in my DB - > so how do I make the Query select only Tick-Boxes that have a tick in them? > If you have a new question, please start a new thread instead of "replying to", otherwise it makes it very difficult to follow what is going on. Anyway, a tick box should be linked to a Boolean field, so either your query can contain any of the following SQL : where 'fieldname' IS TRUE/FALSE where 'fieldname' = 1/0 replace TRUE WITH FALSE or 1 with 0 as appropriate. >From what I remember, a tick box can actually have 3 possible states (a) deactivated (i.e. neither selected nor unselected), (b) selected (value = TRUE or 0) and (c) unselected (value = FALSE or 1). You might like to check whether that is actually the case though, because I might have got TRUE and FALSE mixed up. That is the theory, at least. The reality is that throughout various versions of OOo prior to the existence of LibreOffice, boolean fields linked to tick boxes sometimes behaved rather strangely, and did not work as expected/intended. All I can say is try it out and see whether it works as you wish. Alex -- Unsubscribe instructions: E-mail to [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
