Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
strSQL = "SELECT Count(tblDaily.QCReportNo) " strSQL = strSQL & "FROM tblDaily INNER JOIN (tblInstrumentsUsed INNER JOIN tblInstrumentsDesc ON tblInstrumentsUsed.InstrumentDescId = tblInstrumentsDesc.InstrumentDescId) ON tblDaily.QCReportNo = tblInstrumentsUsed.QCReportNo " strSQL = strSQL & "WHERE (((tblDaily.QCReportNo)=[Forms]![frmPrevDailyDFT]![cboQCRptNo]))" DoCmd.RunSQL (strSQL) dblCount = Count(QCReportNo)
|Trouble with <>||2||21|
|Signature required on a report||5||33|
|Should I use multiple instances of MS Access||13||33|
|Access Lookup issue - creating a new column to look up from a separate table||9||17|