Results 1 to 9 of 9
  1. #1
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142

    report no longer working

    I have a report called the "Daily Coaching Report" that I run that shows an employees weekly work by the day and then gives a weekly average. I have run the report many times but for some reason now when I try to run it I get the "This expression is typed incorrectly , or is to complex" error message. I am not sure why or what has changed. To run the report you enter a persons name ( you can get names from the associate list table. Just put (last name, first name. I have been using Banta, Ron) and then the start and end date. What do you think?
    Attached Files Attached Files

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    I assume you are talking about the 'weekly average report' - without knowing exactly what I am suppose to see, I entered 1/1/2019 and 7/1/2019 I get a result, no error. I suspect it is because you have not specified in your parameters the datatype, or alternatively converted the uk style date (which is text in an input box) to a us style date which is what sql requires when presented with a text value

  3. #3
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142
    No, I am talking about the Daily Coaching Report. The weekly average report is working

  4. #4
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    missed that. You'll need to drill down through the queries - one or more records will have invalid data - qryTaskActivities for example has rows with null values for example

  5. #5
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142
    I have been through every table and every query and cant find a problem with anything that would cause this. Any suggestions outside of scrapping the report and rebuilding it?
    Attached Files Attached Files

  6. #6
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Have you checked data types? Perhaps you are trying to assign a double to an integer or similar

  7. #7
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142
    I'm not sure. Everything was working fine until last week. Then all of a sudden I started getting the error message. I independantly checked all tables and they are all working as well as all query's (except the coaching one) and they are all working. It's like it is being blocked from completing or something. I run the report and it starts compiling and then it shuts down and I get the error message.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I get an Overflow error when I try to open qryDailyAverage. qryTaskActivites shows records with ReportedTime calculated result of 1.00000000000002. I suspect that is source of issue.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    In qryTaskActivities, these rows with taTaskActivitiesID_PK produce garbage results for Utilization, Performance and Efficiency in the same row.
    148
    322
    366
    786
    5501

    When qryDailyAverage tries to average columns with garbage, it fails with overflow.
    Clean up the data and the queries and report work.
    Last edited by davegri; 01-23-2019 at 08:35 AM.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Form no longer working
    By ceatana in forum Forms
    Replies: 3
    Last Post: 05-22-2018, 12:55 PM
  2. DSUM expression on longer working
    By KRS@WAC in forum Access
    Replies: 10
    Last Post: 02-24-2018, 01:29 AM
  3. Relationships working but no longer shown????
    By jimaccessnovice in forum Database Design
    Replies: 5
    Last Post: 02-15-2018, 05:25 PM
  4. Email from Access no longer working
    By Gina Maylone in forum Access
    Replies: 4
    Last Post: 10-12-2016, 06:46 AM
  5. Print button no longer working
    By kris335 in forum Programming
    Replies: 6
    Last Post: 09-28-2012, 08:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums