Showing all records in query

[Guest]

Hello

My tables are as follows

atnMEETINGATTENDANC
F1: MeetingI
F2: ID
F3: AttendanceStatusI

atnMEETIN
F1: MeetingID (autonumber
F2: MeetingNam
F3: MeetingDat
F4: CommitteeI
F5: StartTim
F6: EndTim
F7: LocationI

atnCOMMITTEEMEMBE
F1: CommitteeI
F2: SchoolYearI
F3: ID

I want to be able to present to a secretary the ability to view all the members in a committee, and their status. The problem is that when 'Meetings' are created members are not placed in meetings immediately. What this means is that if the form queries for those people, nobody shows up. I want all the members of the committee to appear, even if they don't have a record in the atnMEETINGATTENDANCE table

How do I go about doing this

Thanks

Eric

 

[Wayne Morgan]

Right click the join link between the tables (this requires a little
precision with the mouse) and choose Properties. There will be an option to
show all records from one table and only those records that match from the
other table.

--
Wayne Morgan
Microsoft Access MVP

Hello,

My tables are as follows:

atnMEETINGATTENDANCE
F1: MeetingID
F2: ID#
F3: AttendanceStatusID

atnMEETING
F1: MeetingID (autonumber)
F2: MeetingName
F3: MeetingDate
F4: CommitteeID
F5: StartTime
F6: EndTime
F7: LocationID

atnCOMMITTEEMEMBER
F1: CommitteeID
F2: SchoolYearID
F3: ID#

I want to be able to present to a secretary the ability to view all the

members in a committee, and their status. The problem is that when
'Meetings' are created members are not placed in meetings immediately. What
this means is that if the form queries for those people, nobody shows up. I
want all the members of the committee to appear, even if they don't have a
record in the atnMEETINGATTENDANCE table.

 

[Guest]

Hello

I've done this - it still does not list all the records from the Committee.

 

[John Vinson]

Hello,

I've done this - it still does not list all the records from the Committee.

Please open your Query in SQL view and post the SQL text here.