#Error values (1 Viewer)

[endri81]

Hi
Using this query I get data as in picture attached.
Maybe because of #Error values (not sure) my report created doesn't run.
First send a message another user ...
then message invalid usage of null

Can you help?

Regards

 

[spikepl]

Please do not start a new thread about the same subject, because the first thing ppl will ask is what is the SQL of the query that you already listed there: http://www.access-programmers.co.uk/forums/showthread.php?p=1150260#post1150260

When your query is OK for some lines but not other, that means the data is different for those lines, then dig into your data. As advised in the other thread: ONE STEP AT A TIME. Stay in the other thread.