Results 1 to 2 of 2

Thread: Access Error Runtime Error 3075

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2020
    Posts
    1

    Access Error Runtime Error 3075

    Code:
    stroverlapQuery = "SELECT SUM(a.Overlapping) AS RESULT FROM " & _
    "( " & _
        "SELECT " & _
            "CASE " & _
                "WHEN ('" & strStartTime & "' BETWEEN Start_Time AND End_Time) OR ('" & strEndTime & "' BETWEEN Start_Time AND End_Time) " & _
                "OR ('" & strStartTime & "' < Start_Time AND '" & strEndTime & "' > End_Time) OR ('" & strStartTime & "' > Start_Time AND '" & strEndTime & "' < End_Time) " & _
                    "THEN 1 " & _
                "ELSE 0 " & _
            "END As Overlapping " & _
        "FROM dbo_tbl_Exceptions " & _
        "WHERE " & _
        "Exception_Date = '" & strExceptDate & "' AND EMP_ID = '" & strEmpID & "' " & _
    ") a "
    
    
    intResult = CurrentDb.OpenRecordset(stroverlapQuery).OpenRecordset.Fields("Result")

  2. #2
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,392

    Re: Access Error Runtime Error 3075

    That error would generally indicate a problem with your query, however, it is probably not the complete error message. The complete message would be helpful.

    Also, the actual text of that huge concatenation of text that builds the query would also be useful in determining where the error is occurring.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width