Data missing in query

[mabyn]

I have combined 4 tables in the following Query. All of the rows filled with
data from the tables except from the last two, ShamrockRating and
Marshallcomments. What should I change to make the table data show up?

SELECT [Attendees].[AttendeeFirstName], [Attendees].[AttendeeLastName],
[Attendees].[CompanyName], [Registration].[Entry Name],
[Registration].[EventID], [ShamrockRatingPossible].[ShamrockRating],
[ShamrockRatingMarshalComments].[MarshallComments]
FROM ShamrockRatingMarshalComments RIGHT JOIN (ShamrockRatingPossible RIGHT
JOIN (Attendees RIGHT JOIN Registration ON
[Attendees].[AttendeeID]=[Registration].[AttendeeID]) ON
[ShamrockRatingPossible].[ShamrockRatingID]=[Registration].[ShamrockRatingID])
ON
[ShamrockRatingMarshalComments].[MarshalCommentsID]=[Registration].[ShamrocksGottenID];


Tble 1 Tble 2 Tble 3 Tble 4
Attendees Registration ShamrockRatingPossible ShamrockRatingMarshalComments

FirstName EventName Shamrockrating (combo) Marshalcomments
Last Name EventID
Company

Thanks in advance.