I have had some luck, at least with locations, in changing the advanced search for locations from a drop-down to a * entry field. So you do an advance search and enter "does not equal" and * in the search. This brings up the null values. But I can't remember exactly how I changed the search function from the drop down to the text entry. I am sure it was in DB config. Caitlin Badowski TMS Administrator (202) 633-8735 [log in to unmask]<mailto:[log in to unmask]> From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Mette Korsholm Sent: Tuesday, February 02, 2016 10:00 AM To: [log in to unmask] Subject: SV: Querying on a null/empty field And I have the problem with "Current location", that I cannot search on an empty value. :) Thanks, Mette Mette Korsholm Registrar [log in to unmask]<mailto:[log in to unmask]> The David Collection Kronprinsessegade 30-32 1306 Copenhagen K Denmark +45 33 73 49 49 www.davidmus.dk<http://www.davidmus.dk> [The David Collection] Fra: The Museum System (TMS) Users [mailto:[log in to unmask]] På vegne af Cousins Ewan, Janette Sendt: 2. februar 2016 15:55 Til: [log in to unmask]<mailto:[log in to unmask]> Emne: Re: Querying on a null/empty field I'd like to know how to do this, too. I've also tried to search for other fields using the "Is Empty" value in the query, but can't seem to make that work. Thanks, Janette Janette Cousins Ewan Art Registrar, Museum London 421 Ridout Street North, London ON N6A 5H4 e. [log in to unmask]<mailto:[log in to unmask]> t. 519.661.2500 x 4269 f. 519.661.2559 www.museumlondon.ca<http://www.museumlondon.ca> From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll Sent: Monday, February 01, 2016 5:42 PM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Querying on a null/empty field Is there a way to query on this field (Accession Value) if there is no value? I have a group of records, some of which do have a value, and some do not. I'd like to segregate those that don't from those that do. Christine Christine Droll Registrar, Database & Collections The Nelson-Atkins Museum of Art 4525 Oak Street | Kansas City, MO 64111 p 816.751.1333 | f 816.751.0499 [log in to unmask]<mailto:[log in to unmask]> [cid:image002.png@01D15DA0.AA60B4B0] To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. ________________________________ Denne mail er blevet scannet for virus af TDC Mailfilter. ________________________________ To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.