Could someone tell me what i'm doing wrong (1 Viewer)

[jonwentz]

i cant seem to get this to work.

any help would be greatly Appreciated

=sum(iif([SADate]>=DateSerial(Year(Date()),Month(Date()),[p]))

thanks in advance

 

[Tim L]

It might help if you could spell out, ie in words, what you are trying to do and if you could say what the error message is that you get.

Without knowing more all I can suggest is, looking at the formulae, are the datatypes compatible?

Tim

 

[jonwentz]

I am trying to get the sum of [p] for the current month to display in a textbox on a form. I am trying to use the code below to to this.

=sum(iif([SADate]>=DateSerial(Year(Date()),Month(Date()),[p]))



I can get the sum of [p] for all records with

=sum([p])

thanks

 

[Tim L]

Have you tried creating a query linked to the date field in the form and displaying the result of that?

Tim