I am trying to calculate a field and am getting datatype mismatch error on the 100 section.
The WOO and PERCENT_WAY_THROUGH_LEASE fields are both set to Long Integer in the table.
I am trying to sum the WOO field where the PERCENT_WAY_THROUGH_LEASE is greater than 100. I have tried single quotes, double quotes and no quotes around the 100 with the same error each time.
If I choose Woo as the column and sum it works. It is only when I try to add the criteria that it throws the error.
The table is joined to another table but it is not joined on either of these fields.
Any help would be awesome