Query Too Complex...Sometimes

  • Thread starter Thread starter bhipwell via AccessMonster.com
  • Start date Start date
B

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
 
What is the code behind the button on the form? Should be something on the On
Click event.
 
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
 
Back
Top