Relationship causing report problem?

[cuttsy]

I have the following tables

tblMembers(memID, firstName, secondName)

tblGuests(guestID, gFirstName, gSecondName)

tblSession(sessionID, sessionDate, sessionTime)

tblBooking(sessionID, memID, guestID)

I have a reprot that will run when a button on a booking form is clicked which is a register of the members attending a session. Its record source is an sql statement made up of the fields from tblSession, tblMembers and tblGuests and should show the date and time of the session in the header. A list of all the members attending and if they have brought a guest then they should appear next to them.

The problem may already be obvious. If a member is booked on a session but has not brought a guest then they do not appear in the report.

I need to know how to set up the report to show all members booked and show any guests that are booked.

 

[cuttsy]

And the answer is

LEFT JOIN / RIGHT JOIN instead of INNER JOIN

Sorted