Query Too Complex...Sometimes

[bhipwell via AccessMonster.com]

Hello,

This seems to be one of those issues I feel like I am just missing. I have a
report that runs off of a query. When the report is called directly from the
report objects list, runs just fine.

However, when the report is called using a button in a form, I get the
infamous "This expression is typed incorrectly, or it is too complex to be
evaluated..."

Any quick thoughts before I go through a long troubleshooting process?

Thanks!

B

 

[Jason Lepack]

Why didn't you post the code so that we can help troubleshoot it?

 

[Guest]

What is the code behind the button on the form? Should be something on the On
Click event.

 

[bhipwell via AccessMonster.com]

Figured it out. The program sits on a separate server and is some work to
copy, paste, email, etc. to get it posted here. Since it works in certain
circumstances, I thought there might be something I missed outside of the SQL.


Anyhow, it was the SUM issue that occurs when using the Select function
versus Group By. After searching through dozens of threads and trying
numberous fixes, finally found the one that applied to me.

Fixed and works fine now.

Thanks!

B