SQL QUERY Runs / REPORT does not

[GUIDO22]

I have modified an existing stock list SQL query that is linked to a report.
Previously the report ran fine - the Query runs without problem when run from the Query window.

But now, if I attempt to open the report to which the Query is attached - I get :

'The Expression Is Typed Incorrectly or it is too complex to be evaluated..... etc.'

If the expressions were typed incorrectly or too complex - presumably, when I ran the query from the Query window - Access would have complained with a similar message?

So, why is this error only appearing when I run the report? Any ideas why this could be occuring?

Thank you.

 

[GUIDO22]

Sorry - I have found similar postings on this forum that suggest that it is not the Query tht is the problem. Sure enough - I have played around with the report and for some reason - a field on the report :

=Sum([Value])

Is the culprit. If I remove this control from the report - everything runs fine.

Why would a text field carrying a total for a section of a report now cause a problem where before there was none...??

 

[GUIDO22]

Found it - I appear to have NULL values appearing in the resultset.
This is likely upsetting the SUM function - Consider this fixed!