Thanks Duane,
I will follow your advice and design the report differently.
Cheers,
Robin
At 29/03/2012 01:09 PM, you wrote:
>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
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
Tidak ada komentar:
Posting Komentar