Query Issue

[Welshgasman]

I'm so sorry welshgasman I didn't understand anything you wrote, I'm still learning... "Run the query on it's own and inspect TermExpires" not sure how..."just a ZLS ?" what is ZLS

I am assuming you have a query for the form recordsource, [quote]" however I created a calculation in a query using IIF"[Quote]
A ZLS is short for Zero Length String, which is exactly what it says a string of zero length, that 'looks like' it could be Null.

So I am saying inspect your data.
Alternatively do what I always did, walk through your code line by line, inpecting values.

See debugging tips in my signature.

[Micron]

Since you can't see the difference between null and zls, query the table and set the criteria for the suspect field to ""
That will tell you if records contain zls. If not, the query will produce no result. Unless the data comes from some other source or application, I doubt you have any zls values.

[x2dull4u]

My video, even zipped was to large, I uploaded the video go my google drive. I don't blame you if you choose not to trust the link, however he it is... https://drive.google.com/drive/folde...r8?usp=sharing
thank you