Hi Lisa I think there is a way but you have to do something in configuration menu to prevent the field value from being a dropdown. GS helped me with this. I think you go to manage table/columns in configuration, select objects, then locations and right click. Then untick 'display as distinct list in queries' under attributes in the edit column box (see below). I did this a long time ago, so maybe check with GS if this is correct before you do it! That way I can search on field value is not equal to * for the site. Thanks Caroline Caroline Delahunty TMS Officer National Gallery of Ireland Merrion Square West Dublin 2 tel: 01 632 5525 * Help save paper - do you really need to print this email ? ________________________________ From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Gaunt, Lisa Sent: 05 March 2007 15:36 To: [log in to unmask] Subject: searching for records with no current location Could anyone tell me if there is an easy way to search for records that have no current location recorded? Lisa Gaunt Documentation Manager Bolton Museums, Art Gallery & Aquarium Le Mans Crescent Bolton BL1 1SE 01204 332173 www.boltonmuseums.org.uk This e-mail and any attached files are confidential and may also be legally privileged. They are intended solely for the intended addressee. If you are not the addressee please e-mail it back to the sender and then immediately, permanently delete it. Do not read, print, re-transmit, store or act in reliance on it. This e-mail may be monitored by Bolton MBC in accordance with current regulations. This footnote also confirms that this e-mail message has been swept for the presence of computer viruses currently known to the Council. However, the recipient is responsible for virus-checking before opening this message and any attachment. Unless expressly stated to the contrary, any views expressed in this message are those of the individual sender and may not necessarily reflect the views of Bolton MBC. http://www.bolton.gov.uk *********************************************************************************** Exhibitions at the National Gallery of Ireland, http://www.nationalgallery.ie/html/exhibitions.html *********************************************************************************** The information contained in this email and in any attachments is confidential and is intended solely for the use and attention of the intended recipient(s). This information may be subject to legal & professional privilege. If you are not an intended recipient of this email, you must not use, disclose, copy, distribute or retain this message or any part of it. If you have received this email in error, please notify the sender immediately and delete all copies of this email from your computer system(s). This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. The National Gallery of Ireland Merrion Square West Dublin 2 Ireland Tel: 353-1-661 5133 Fax: 353-1-661 5372 http://www.nationalgallery.ie **********************************************************************************