Querying Null Date Value

[Ice Rhino]

OK. Sorry I missed that earlier on in this thread. I will give that a go

Regards

 

[Ice Rhino]

You know what Brian, I just fell in Love with you

IT WORKS!!!!!!!!!!

Thank you so much for all your help. I am going to read through what you have actually typed and try to understand it so that I can at least learn something from this.

Kindest Regards

 

[Ice Rhino]

Just to throw a spanner in the works. If the value of Null is being searched for as part of the overall search, I have two boxes DateFrom and DateTo that obviously have no value in the them when displayed to the enquiring user. What road should I reserach to make the value of this box display 'Not Applicable'? or is this way outside capabilities because I will be asking text to be placed in a date field

if it is too much hassle, forget I asked, happy with what I have, just wanted to add some polish

Regards

 

[Brianwarnock]

Not having much time to get on the forum at the moment, glad things worked out. As to the last post yes I would expect you to get an error if you tried to put text into a date field, how about placing 2 other fields over the date boxes and switching visibility according to whether you are looking for null or not?

Brian

 

[Ice Rhino]

Brian, and there was I thinking you sat there 24/7 waiting for my every enquiry.

Yeah, the switchy box thingy could work. Will head off down that road

Thanks