Mike: Are there any NULL values in the field? NULL won’t be included in a <> evaluation. To include NULL values, you would have to write: “Complete” <> ‘yes’ or “Complete” is NULL (Assuming that a NULL value means that it isn’t complete). Hope this helps, Jay From: Northeast Arc Users Group [mailto:[log in to unmask]] On Behalf Of Mike Sent: Thursday, November 08, 2018 12:54 PM To: [log in to unmask] Subject: Definition Query on Hosted Feature Layer Hello Everyone, I am just curious as to if anyone else has experienced this issue: When applying a definition query to a hosted feature layer from within arcmap, the results are inaccurate/records dropped. I'm running a simple hosted feature layer for field notes with a field for 'complete', 'yes/no'. "Complete" <> 'yes' will return some but not all of the results. The total number of records is under 1000, so I don't believe it's a matter of too many returns. I'm running arcmap 10.4.1. That's probably the crux of the issue so if anything, now ya know! Cheers, Mike Ray ------------------------------------------------------------------------- This list (NEARC-L) is an unmoderated discussion list for all NEARC Users. If you no longer wish to receive e-mail from this list, you can remove yourself by going to http://s.uconn.edu/nearcsubscribe. ------------------------------------------------------------------------- This list (NEARC-L) is an unmoderated discussion list for all NEARC Users. If you no longer wish to receive e-mail from this list, you can remove yourself by going to http://s.uconn.edu/nearcsubscribe.