CODE EXAMPLE FOR SQL

characters found after end of sql statement

    SQL_Output = "SELECT TblTcAOG.ID, TblTcAOG.Date, TblTcAOG.STN, TblTcAOG.REG, TblTcAOG.ATA, TblTcAOG.[ATA2Digit Description], TblTcAOG.ATA4DIGIT, TblTcAOG.ATA2DIGIT, TblTcAOG.ATALAST2, TblTcAOG.[REASON FOR AOG], TblTcAOG.[AOG HRS], TblTcAOG.[AOG MINS], TblTcAOG.AOGTime, TblTcAOG.AOGTotalMins, TblTcAOG.[Event Type], TblTcAOG.[Severity Index], TblTcAOG.[Dispatched IAW MEL], TblTcAOG.[MEL Reference], TblTcAOG.[ETOPS Sector], TblTcAOG.[Charter Flight], tblactype.actypeid, tblactype.Manufacturer, tblactype.Type " & _
                 "FROM (tblactype INNER JOIN TblAcrft ON tblactype.[actypeid] = TblAcrft.[ModelLink]) INNER JOIN TblTcAOG ON TblAcrft.[Reg] = TblTcAOG.[REG]; " & _
                 "WHERE ((TblTcAOG.Date)>=" & dStart & " And (TblTcAOG.Date)<=" & dEnd & " AND ((TblTcAOG.AOGTotalMins)>=[forms]![FrmRptCriteriaAOG]![AOG_Time])) "