troubleshooting Question

IsNotNull - in query design

Avatar of pdvsa
pdvsaFlag for United States of America asked on
Microsoft AccessSQL
6 Comments1 Solution304 ViewsLast Modified:

I am trying to modify the below query.  Access gives me an error of undefined function on the "IsNotNull".  I dont think I can use IsNotNull in the query.  Is there a work around or a better idea?  Please see bold    I also tried [ContractAward]<>"" but got a data type mismatch error.  Also note that the query worked fine until I added the IsNotNUll part so there is not a naming issue and if I take out the IsNotNull section then it works fine.

thank you.

MyGroup: IIf([tblStatus.Status] Like "*Awarded*" Or [tblStatus.Status] Like "Won*" Or IsNotNull([ContractAward],"Awarded",GetGroup([Projects.BidCloseDate],[Projects.ATTApprvDate],[Projects.ATCApprvDate],[Projects.ATSApprvDate],[Projects.ContractAward],[Projects.AnticipatePOSignDate],[Projects.CorpATTDate],[Projects.ExpectedContractAward])))

IsNotNull Error
Information Technology Specialist

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros