Report not showing data from query

[mari_hitz]

Hi everyone,

I have a question. I have a database and I had created a query that sums records and performs an Iif.
When I create a report based on the query, the report brings the data for the column with the "If" properly, however the information of the Sums is not available. The column is empty.

In addition, my Sum in the query is called "SumTXV" and the iff is "Expr1", when I run the query brings me pop ups with both of the names of the columns similar to insert criteria, do you know why all of this is happening to me?

Thanks!

 

[pr2-eugin]

Have no clue what you are talking about. How about you show us the Query.?

 

[mari_hitz]

Hi pr2-eugin!

Please find my database here and you will be able to see the annoying pop up that appears, in addition, the report with the same pop ups and with no data on the columns that refer to the sums in the query. The report is based on qry4
I want to know how can I do for the report to show the data on the columns that are blank -which actually have information on the query-

Sorry If I am not clear.