Solved

Access error- This expression is typed incorrectly or it is too complex to be evaluated....

Posted on 2014-11-03
2
1,305 Views
Last Modified: 2014-11-14
Hi.  Users are running a report that has worked for years and is now issuing an error on request: This expression is typed incorrectly or it is too complex to be evaluated....   I traced it back to the report itself.  In my report footer I created a calculated field and am summarizing a detail column total.  My expression is =Sum([RGAQtyReq]).  
Is there a better way to format this expression?  thanks
0
Comment
Question by:valmatic
2 Comments
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40420517
Either there is some bad data in the table or the report has become corrupted.  If all the users are getting the error (and you haven't just pushed out a new copy of the FE), then I would examine the data.  Try a compact and repair on the BE and then again on each copy of the FE.  You might also run the /Decompile on the FE and distribute a new copy of the FE.
0
 
LVL 7

Author Comment

by:valmatic
ID: 40441024
ok
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now