asked on
What is wrong with this code?
I am getting a #ERROR
=IIf(IsNull(DSum("[amtpaid]","interest","[paiddate] between >=DateSerial(Year(Date())-1,1,1) and date()-365")),0,DSum("[amtpaid]","interest","[paiddate] between DateSerial(Year(Date())-1,1,1) and date()-365"))
Microsoft Access
Last Comment
Maria Barnes
ASKER CERTIFIED SOLUTION
THIS SOLUTION 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.
A little easier if you put it in a query to debug. Looks like Jim's statement is correct.
=IIf(IsNull(DSum("[amtpaid]","interest","[paiddate] between >=#" & DateSerial(Year(Date())-1,1,1) &"# and #" & (date()-365) & "#")),0,DSum("[amtpaid]","interest","[paiddate] between >=#" & DateSerial(Year(Date())-1,1,1) &"# and #" & (date()-365) & "#"))