[MS_AccessPros] Re: Including all clubs in a report

 

Are you sure the query doesn't return all clubID records frm ClubsActive? Or, are you opening a filtered report based on one of the fields from tAttendance?

Have you considered a main report based on ClubsActive with a subreport to display the tAttendance records?

Duane Hookom
MS Access MVP

--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple <robinski@...> wrote:
>
> 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 (2)

Recent Activity:

• New Members 6
• New Files 3

Visit Your Group

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

.

__,_._,___