checking for non null values in a database.

[Jovix]

I didn't know how to describe the problem on the subject line but here it is. I have a program that looks at a database. One of my tables has four date fields and depending on the data entry criteria, only one of those date fields will be populated. I need a piece of code that will check all for fields and only return the one that is not null. I was thinking of using and IF Then statement. But I'm not sure what to do.

thanks in advance
Jovix

 

[SemperFiDownUnda]

if you are using SQL Server as your database then look up

CASE SQL Syntax

Hope I've been helpful,
Wayne Francis

If you want to get the best response to a question, please check out FAQ222-2244 first

 

[MattSTech]

Using the "If Then", replace "MyRecordset.Field" with your info.

If Not IsNull MyRecordset.Field then
msgbox "Field contains data"
Else
msgbox "Field is Null"
End if


Matt