I have a query that has an expression IIf(Not IsNull([Field1]),1,0). When i run the query it works fine, but when i put it into a report, the numbers are wrong. In the query there was one 1, in the report there are 6. Can anyone explain why?



Thank you!