Solved

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

Posted on 2014-11-03
2
1,333 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 35

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

813 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

14 Experts available now in Live!

Get 1:1 Help Now