P pgsibson Registered User. Local time Today, 22:18 Joined Jan 24, 2008 Messages 44 Jan 26, 2008 #1 I am trying to create a select query on "ApprovedDate" where no approval is recorded. IsNull returns an expected type mismatch. Any ideas? Regards
I am trying to create a select query on "ApprovedDate" where no approval is recorded. IsNull returns an expected type mismatch. Any ideas? Regards
KenHigg Registered User Local time Today, 17:18 Joined Jun 9, 2004 Messages 13,327 Jan 26, 2008 #2 I think you simply need to make that Is Null with no quotes around it instead of "IsNull"... ???
P pgsibson Registered User. Local time Today, 22:18 Joined Jan 24, 2008 Messages 44 Jan 26, 2008 #3 Thanks Why didn't I think of that!
