Handling Null in DSum

[Anthony Viscomi]

What can I place in the following statement in order to make provisions for
Null?

Dim TotalDueX As Integer
TotalDueX = DSum("[Cost]", "[dbo_course]", "[SS] = '" & Me!SS & "'")

Thanks!
Anthony

 

[CJR]

Anthony

Dim TotalDueX As Integer
Dim iTemp as variant
iTemp= DSum("[Cost]", "[dbo_course]", "[SS] = '" & Me!SS & "'")
TotalDueX =iif(isnull(iTemp),0,iTemp)

The last line substitutes the value 0 if iTemp IS NULL (replace the 0 with
the desired default value)

Hope this helps

Chris

 

[Anthony Viscomi]

Great! Thanks

Anthony

Dim TotalDueX As Integer
Dim iTemp as variant
iTemp= DSum("[Cost]", "[dbo_course]", "[SS] = '" & Me!SS & "'")
TotalDueX =iif(isnull(iTemp),0,iTemp)

The last line substitutes the value 0 if iTemp IS NULL (replace the 0 with
the desired default value)

Hope this helps

Chris

What can I place in the following statement in order to make provisions
for Null?

Dim TotalDueX As Integer
TotalDueX = DSum("[Cost]", "[dbo_course]", "[SS] = '" & Me!SS & "'")

Thanks!
Anthony

 

[Steve Schapel]

Anthony,

TotalDueX = Nz(DSum("[Cost]", "[dbo_course]", "[SS] = '" & Me!SS & "'"),0)