Moveing a Form from mdb to adp

[Jon]

I'll try to make this simple

i have a Continuous form with 7 columns.

sadate, p, ps, i, is, a, as


i would like to be able to SUM these by current month, quarter, year (to date)

this is the code that i used for mdb (replace [p] with other columns)

MTD
=Sum(IIf(DatePart("m",Date())=DatePart("m",[sadate]),[p],0))

QTD
=Sum(IIf(DatePart("m",Date())=DatePart("q",[sadate]),[p],0))

YTD
=Sum(IIf(DatePart("m",Date())=DatePart("yyyy",[sadate]),[p],0))

after i moved the form to adp all i get are errors,


thanks in advance