E
Eric Chajmovic
Hello
The following query works when I execute it from the Queries window. When I open a report that uses this query as the recordsource though, I get an 'Error in From Clause'. Any ideas
TRANSFORM Count(atnMEETINGATTENDANCE.[ID#]) AS [CountOfID#
SELECT Trim([names].[lastn] & ', ' & [reftitle].[title] & ' ' & [names].[firstn] & ' ' & [names].[middle]) AS [Member Name
FROM ([Names] LEFT JOIN refTITLE ON Names.Prefix = refTITLE.TitleID) RIGHT JOIN (atnMEETING LEFT JOIN atnMEETINGATTENDANCE ON atnMEETING.MeetingID = atnMEETINGATTENDANCE.MeetingID) ON Names.[ID#] = atnMEETINGATTENDANCE.[ID#
WHERE (((atnMEETING.CommitteeID)=2) AND ((atnMEETING.MeetingDate)>Date()-365)
GROUP BY Trim([names].[lastn] & ', ' & [reftitle].[title] & ' ' & [names].[firstn] & ' ' & [names].[middle]), Names.LastN, Names.FirstN, Names.Middl
ORDER BY Names.LastN, Names.FirstN, Names.Middl
PIVOT atnMEETING.MeetingDate
The following query works when I execute it from the Queries window. When I open a report that uses this query as the recordsource though, I get an 'Error in From Clause'. Any ideas
TRANSFORM Count(atnMEETINGATTENDANCE.[ID#]) AS [CountOfID#
SELECT Trim([names].[lastn] & ', ' & [reftitle].[title] & ' ' & [names].[firstn] & ' ' & [names].[middle]) AS [Member Name
FROM ([Names] LEFT JOIN refTITLE ON Names.Prefix = refTITLE.TitleID) RIGHT JOIN (atnMEETING LEFT JOIN atnMEETINGATTENDANCE ON atnMEETING.MeetingID = atnMEETINGATTENDANCE.MeetingID) ON Names.[ID#] = atnMEETINGATTENDANCE.[ID#
WHERE (((atnMEETING.CommitteeID)=2) AND ((atnMEETING.MeetingDate)>Date()-365)
GROUP BY Trim([names].[lastn] & ', ' & [reftitle].[title] & ' ' & [names].[firstn] & ' ' & [names].[middle]), Names.LastN, Names.FirstN, Names.Middl
ORDER BY Names.LastN, Names.FirstN, Names.Middl
PIVOT atnMEETING.MeetingDate