Avatar of pdvsa
pdvsaFlag for United States of America

asked on 

IsNotNull - in query design

Experts,

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])))


User generated image
Microsoft AccessSQL

Avatar of undefined
Last Comment
awking00
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Try:

Or Not IsNull([ContractAward])
Or like this perhaps?

Or Not IsNull([ContractAward],"Awarded",GetGroup([Projects.BidCloseDate],[Projects.ATTApprvDate],[Projects.ATCApprvDate],[Projects.ATSApprvDate],[Projects.ContractAward],[Projects.AnticipatePOSignDate],[Projects.CorpATTDate],[Projects.ExpectedContractAward])))
ASKER CERTIFIED SOLUTION
Avatar of awking00
awking00
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

False was the solution.  thank you.
awking00
Good catch...
(I missed that aspect)...
;-)

Jeff
Avatar of awking00
awking00
Flag of United States of America image

boag2000, thanks
and
pdvsa, you're welcome.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo