TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Querying on a null/empty field
From:
Christine Droll <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Mon, 1 Feb 2016 22:42:05 +0000
Content-Type:
multipart/related
Parts/Attachments:
text/plain (24 kB) , text/html (4 kB) , image001.png (24 kB) 
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]


[cid:image001.png@01D15D0F.61AAC850]



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.

ATOM RSS1 RSS2