Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2014-11-03
2
Medium Priority
?
1,533 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 39

Accepted Solution

by:
PatHartman earned 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

730 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