I have a report reading from a query. I have a column with defined as alpha which has mostly characters in, but on certain rows (with "Daily" in field1, there are some totals, left justified, e.g., 0.5 and 2.5
I keep getting a "data mismatch" using" =IIf([field1]="Daily" And Not IsNull([sainx]),Sum(Val([sainx])),
I see it is likely trying to somehow sum the rows with actual alpha data in them
Also wondering if I need to sum up a "dummy" field in the detail section, and then reference that field in the report footer, or cud the code just be placed into the report footer ?
I keep getting a "data mismatch" using" =IIf([field1]="Daily" And Not IsNull([sainx]),Sum(Val([sainx])),
I see it is likely trying to somehow sum the rows with actual alpha data in them
Also wondering if I need to sum up a "dummy" field in the detail section, and then reference that field in the report footer, or cud the code just be placed into the report footer ?
Last edited: