G
Guest
Can someone please tell me what I am doing wrong. Here is what I have:
=DSum("[NI]","[tblProductionData]","[ProgramType]=" & [ProgramType] And
NZ([PostcardPhase],0)='" & NZ([PostcardPhase],0) & "' And [Resort]='" &
[Resort] & "' And [Team]=" & [Team] And [CallCenter]='" & [CallCenter] & "'
And [Date]=#" & [Date] & "# ")
[ProgramType] and [Team] are numbers, [Date] is date, and the rest are text.
I am not getting an error, just a blank field. Please help, I've been
fighting with this for days. Thanks.
=DSum("[NI]","[tblProductionData]","[ProgramType]=" & [ProgramType] And
NZ([PostcardPhase],0)='" & NZ([PostcardPhase],0) & "' And [Resort]='" &
[Resort] & "' And [Team]=" & [Team] And [CallCenter]='" & [CallCenter] & "'
And [Date]=#" & [Date] & "# ")
[ProgramType] and [Team] are numbers, [Date] is date, and the rest are text.
I am not getting an error, just a blank field. Please help, I've been
fighting with this for days. Thanks.