Search results

  1. S

    SELECT specific via filter or select all if no filter

    SELECT tblReports.ReportID, tblAgency.AgencyName, tblReports.PeriodType, tblReports.PeriodEnded, tblReports.Completed FROM tblAgency INNER JOIN tblReports ON tblAgency.AgencyID = tblReports.AgencyID WHERE ( ( [forms]![frmnavigation]![masterfilter] = 0 ) OR (...
  2. S

    how to write these queries

    How about adding a few lines to MSAccessRookie's query just before the GROUP BY line: WHERE CodeTable.Code_ID NOT IN ( SELECT Code_ID FROM DataTable GROUP BY Code_ID, StartDate HAVING Count(*) > 1 )
Back
Top Bottom