Runtime Error 3000 - Reserved error -3087

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

OK - What's wrong with this picture.... It worked in 2003 but not 2007.

I have a report full of Unbound Text Boxes that I fill with Quartlerly
Revenue $$. The report works untill I add a third table for "Team Name" -
which is new because we need counts of Each Person (who may be on several
teams). Below is the query, it runs fine and I get the setup I want.
However, when it's in the report I get this Runtime Error 3000 - reserved
error (-3087). Why?

TRANSFORM Sum(tblRevenue.RevenueAmount) AS Revenue
SELECT tblRoster.OfficeType AS OfficeType, tblRoster.Region AS Region,
IIf([tblroster].[officetype]="Partner",[tblTeamnames].[Description] &
"*",[tblTeamnames].[Description]) AS TeamID,
IIf(IsNull(tblroster.middlename),tblroster.firstname & " " &
tblroster.lastname,tblroster.firstname & " " & tblroster.middlename & " " &
tblroster.lastname) AS Member
FROM (tblRoster INNER JOIN tblRevenue ON tblRoster.EmployeeID =
tblRevenue.MemberID) INNER JOIN tblTeamNames ON tblRoster.MultTeamName.Value
= tblTeamNames.ID
WHERE (((DatePart("yyyy",[tblrevenue].[quarter]) & "Q" &
DatePart("q",[tblrevenue].[quarter]))>=Year(Now())-1 & "Q" &
DatePart("q",Now())+1))
GROUP BY tblRoster.OfficeType, tblRoster.Region,
IIf([tblroster].[officetype]="Partner",[tblTeamnames].[Description] &
"*",[tblTeamnames].[Description]),
IIf(IsNull(tblroster.middlename),tblroster.firstname & " " &
tblroster.lastname,tblroster.firstname & " " & tblroster.middlename & " " &
tblroster.lastname)
PIVOT DatePart("yyyy",tblrevenue.quarter) & "Q" &
DatePart("q",tblRevenue.quarter);


Thanks.
 
Back
Top