Hello All

i have a Continuous form with 2 columns.

sadate, p

i would like to be able to SUM this by current month (to date)

this is the code that i used for mdb

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

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


thanks in advance

How about some sample data and DDL of your table? Please

Shahchi1

hummmm
sample data, its just numbers

my table is on the sql server

i failed to put in my first post that this string is a control source on a textbox