Confused on needing If Statement or Trim or WHERE

[mabyn]

In the Query I am working on there are many records I do not need from one of
the tables. If there is no "ENTRY NAME" or , then I need the query not to
show the record.

SELECT [Registration].[RegistrationID], [Registration].[Entry Name],
[Attendees].[AttendeeFirstName], [Attendees].[AttendeeLastName],
[Lineup].[Head of Parade], [Lineup].[Band Staging], [Lineup].[Group 2],
[Lineup].[Group 1], [Lineup].[Group 3]
FROM (Attendees LEFT JOIN Registration ON
[Attendees].[AttendeeID]=[Registration].[AttendeeID]) LEFT JOIN Lineup ON
[Attendees].[AttendeeID]=[Lineup].[AttendeeID];WHERE [Registration].[Entry
Name] = ????

This is my try.

 

[bcap]

SELECT [Registration].[RegistrationID], [Registration].[Entry Name],
[Attendees].[AttendeeFirstName], [Attendees].[AttendeeLastName],
[Lineup].[Head of Parade], [Lineup].[Band Staging], [Lineup].[Group 2],
[Lineup].[Group 1], [Lineup].[Group 3]
FROM (Attendees LEFT JOIN Registration ON
[Attendees].[AttendeeID]=[Registration].[AttendeeID]) LEFT JOIN Lineup ON
[Attendees].[AttendeeID]=[Lineup].[AttendeeID] WHERE [Registration].[Entry
Name] IS NOT NULL