Search results

  1. B

    Records on Join Table

    I Have the following query: SELECT Count(tblBookings.BookingID) AS CountOfBookingID, tblSessions.SessionID, tblSessions.SessionDate FROM tblCourses INNER JOIN ((tblVenues INNER JOIN tblSessions ON tblVenues.VenueID = tblSessions.VenueID) INNER JOIN tblBookings ON tblSessions.SessionID =...
  2. B

    Eliminating Duplicate Records

    I Have the following query: SELECT tblDelegates.DelFirstName, tblDelegates.DelSurname, tblSessions.SessionID, Format([tblDelegates.DateSubmitted],'dd/mmm/yyyy hh:nn') AS [DateTime], tblDelegates.DelID, tblCourses.CourseName FROM (tblCourses INNER JOIN (tblDelegates INNER JOIN tblSessions ON...
Back
Top Bottom