Solved

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

Posted on 2014-11-03
2
1,268 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
Comment Utility
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
Comment Utility
ok
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
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…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

772 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

12 Experts available now in Live!

Get 1:1 Help Now