[MS_AccessPros] Including all clubs in a report

 

Using Access 2007

This is a variation on a report that I had help with in September last year.

I have an attendance report needs to include clubs that have not made
a monthly report. This SQL was intended to show all clubs but it only
shows those with data in "tAttendance".

SELECT ClubsActive.ClubID, tAttendance.TotalMembers,
tAttendance.MonthPerCent, tAttendance.MeetingsHeld,
tAttendance.NewMembers, tAttendance.Terminated,
tAttendance.ReportMonthID, tAttendance.ReportMonth
FROM tAttendance RIGHT JOIN ClubsActive ON tAttendance.ClubID =
ClubsActive.ClubID

What have I missed?

Many thanks,

Robin Chapple

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6
• New Files 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___