Hepl....subform Calculation

[zaky]

HI. I'M TRYING TO CALCULATE SUBFORM. THE TOTAL OF THE SAME DATE LET SAY TODAY'S DATE IS (APR 20 03)

APR 19 03 $400
APR 20 03 $100
APR 20 03 $200

I WANT THE TOTAL TO GIVE ME $ 300 NOT $700

THANX I REALLY NEED IT SO BAD...

 

[Rich]

=Sum(Iif([MyDate]=Date()),[MyField],0)

 

[zaky]

=Sum(Iif([MyDate]=Date()),[MyField],0)

thanx Rich for your help but where am i going to put the expression


thanx again....

 

[Rich]

Add the expression as the control source for an unbound textbox in the subform footer

 

[zaky]

I'm deeply sorry that i posted the same one twice..... and thanx
Rich but it is giving me an error whenever i put "=" sign infront of it like
=sum(Iif([Date]=date()),[amount],0) it is saying


the expression you entered has a function containing the wrong number of arguments


thanx again Rich....

 

[Rich]

Oops
=sum(Iif([Date]=date(),[amount],0))
you should re-name you field Date to something else, it's going to cause you problems in the future

 

[zaky]

After I renamed it worked abssolutelly perffect thank you A million
Rich you are the man reaaaaaallly happy.
And you made my whoole year "not my day".


Thank you,Thank you, Thank you "RICH"