Access: IIF And Questions

[gheyman]

How do you do an "And" formula. I have an IIf statement that works

KickOff_A: IIf([tblProposalStatus]![KickOff_Applicable]=-1,[tblProposalStatus]![KickOff_Actual]-[QUOTES MASTER TABLE]![Date Received],"0")

I want to add an "And" part to it. If [KickOff_Actual] is not Null AND [Date Received] is not Null

 

[Joe4]

You pretty much has the correct structure.
See this example: https://www.mrexcel.com/forum/microsoft-access/71636-iif-statement-access.html

 

[gheyman]

Thanks!

 

[Joe4]

You are welcome.