Data type mismatch in criteria expression.

[pipoconanan45]

Hi everyone.

Im trying to make report where a textbox displays the sum of all the value of a specific field if condition is met.

This is my code.

=Sum(IIf([FieldID]="1",[FieldData],0))

The Data type of [FieldData] is Number and the "Field Size" is Double. Im using double because the data have to have up to 2 decimal place. I think this is the reason for the error.

Ive used this code before but when I tried to use it again I get this error.




I also tried using this code but it ignores the condition and displays the sum of all the data in the [FieldData].

=IIf([FieldID]="1",(Sum([FieldData])),0)

Is there anyway to solve this? Thank you in Advance.

[ranman256]

this should be done in the query, not the report (but it can)
this way the report just points to fields.

But access cannot sum strings. check the [FieldID]="1"
ID s are not usually strings, they are numeric...
iif([FieldID]=1,sum())