Search results

Neil, your not making any sense to me at all. If you know what to do then adjust the query and send it to me.

From the SQL View I went to Design View and right clicked the relationship, selected join properties and then number 2: 'Include all records from tblSessions' and those records from 'tblBookings' where the table field are matched, this changed the inner join to left join but still no record...

Ok, so what will the new SQL be.

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 =...

Hello there, I would like to see the most recent record for tblDelegates_Audit.auditdate. Thank you.

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...