Hi Katharina, We use login id does not equal * to capture these. Best, Stephanie Stephanie Hansen Rights & Reproductions / Database Administrator Milwaukee Art Museum 700 N. Art Museum Dr. | Milwaukee, WI 53202 Tel. 414.224.3268 | Fax. 414.271.7588 | [log in to unmask] More at www.mam.org Kids 12 and under are FREE -----Original Message----- From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Szlezak Katharina (K1) Sent: Friday, July 15, 2011 4:43 AM To: [log in to unmask] Subject: Searching for Objects with no location entered Hello, I hope someone can help with that: To move all objects in our database which have no location entered yet to their actual location, I tried to run a query by LocationID = -1, but the Advanced Query Assistant told that it cannot run such a query. Does anyone know how to filter all objects where it says something like "no location entered" in the location display field in the standard data entry (all objects where upon creation no location has been entered)? Thanks a lot for your help! Cheers, Katharina Szlezak MMag. Katharina Szlezak TMS-Administratorin Provenienzforschung Landhausgalerie Ausstellungsbrücke Abteilung Kunst und Kultur Amt der NÖ Landesregierung Landhausplatz 1 A-3109 St. Pölten T 0043-2742-9005-15916 F 0043-2742-9005-13029 E [log in to unmask] 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. 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.