Results 1 to 3 of 3
  1. #1
    billybeer is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2015
    Posts
    27

    Run-time error '3071'

    I have a report that runs from a query that gets it's date parameters from a form. When I run it, everything is fine as long as the dates I run does not include the date of June 22, 2015. If that date is included I get a "Run time error '3071' This expression is typed incorrectly, or it is too complex to be evaluated..." How can one particular date cause a problem?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Does the date in the box look like: 7/22/2015 ?
    when you run the query (the report uses) does it open correctly?
    is the date used in a function? (in the query)
    is there code in the report that does calcs on fields?


  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    That is odd, no idea why that happens. Would have to review code and report design.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    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.

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

Similar Threads

  1. Query Error 3071
    By fooforever in forum Queries
    Replies: 4
    Last Post: 04-15-2011, 06:15 AM
  2. Help with Error (3071)
    By ron3rbns in forum Access
    Replies: 1
    Last Post: 03-05-2011, 01:56 AM
  3. Need help with Error (3071)
    By ron3rbns in forum Queries
    Replies: 0
    Last Post: 03-03-2011, 10:35 AM
  4. error 3071 on OpenReport command
    By degras in forum Reports
    Replies: 5
    Last Post: 02-15-2011, 10:40 AM
  5. Microsoft Access Error 3071
    By Ev0luTioN in forum Access
    Replies: 1
    Last Post: 08-04-2010, 04:35 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