SQL query help needed I think

[mabyn]

I am drowing in Access and need more assistance please. I have 3 tables I
need to get information from:
Attendees Table (Company Name), (First Name), (Last Name)
Registration Table (Entry Name) (Registration ID #)
Lineup Table (Head) (Band Staging Area) (Group 1) (Group 2) (Group 3)

The Attendees Table and Registration Table share an Attendees ID. The
Registration Table and Lineup table share the Registration ID.

I think I've written this every way I know how to. I ULTIMATELY need a
report that will print:

Entry Name/Registration ID/Company/First Name/Last Name/and then either the
Head, Band Staging ARea, Group 1, or group 2 or group 3. Every Entry Name is
assigned to one of those areas.

My sql is as follows: SELECT [Registration].[Entry Name],
[Registration].[RegistrationID], [Attendees].[CompanyName], [Lineup].[Head of
Parade], [Lineup].[Band Staging], [Lineup].[Group 2], [Lineup].[Group 1],
[Lineup].[Group 3], [Attendees].[AttendeeFirstName],
[Attendees].[AttendeeLastName]
FROM (Attendees LEFT JOIN Lineup ON
[Attendees].[AttendeeID]=[Lineup].[AttendeeID]) INNER JOIN Registration ON
[Attendees].[AttendeeID]=[Registration].[AttendeeID];

I'm getting all of the data I need on the query EXCEPT the values of (Head
of Parae, band staging, group 1,2 & 3) do not show up. They look like little
greyed boxes on the query.

Suggestions will be appreciated. Thanks.

 

[mabyn]

Okay. What I need to know is why would Yes/No boxes show up as little grey
boxes and not show up as a yes or a no? I need my Yes/No's to show from a
table to the query and I need to sort by those.
All of my lineup table has options like:
Head
BandStaging
Group 1

They are currently marked yes/no. I'm sure there is/was a better way to do
this. Each record indicates a participant in a St. Patrick's Day Parade. I
need to tell program where they are to report on parade morning. They can go
several places - Head of Parade, Band Staging ARea, and then there are other
participant areas Called Group1, Group 2, and Group 3.