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
t. 519.661.2500 x 4269 f. 519.661.2559
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]
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
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.