B
Betti via AccessMonster.com
Good day ,
I have been trying to find a fix for my problem with no luck. I am trying to
run a CrossTab query that is based on another nested query and I keep on
getting Error 3070. I don't have a parameter in any of my queries and I
changed the name of my fields so I am not useing a reserved word. The
followning is my Query:
TRANSFORM Count([Volume By BusUnit - Vendor Top BusUnit].[Request Count]) AS
[CountOfRequest Count]
SELECT [Volume By BusUnit - Vendor Top BusUnit].FirstDayOfWeek
FROM [Volume By BusUnit - Vendor Top BusUnit]
GROUP BY [Volume By BusUnit - Vendor Top BusUnit].FirstDayOfWeek
PIVOT [Volume By BusUnit - Vendor Top BusUnit].[Business Unit];
I am getting an error on [Volume By BusUnit - Vendor Top BusUnit].
FirstDayOfWeek
which is based on (This query runs without a problem) :
SELECT DISTINCT [ Volume By BusUnit - Vendor].FirstDayOfWeek,
Max([Volume By BusUnit - Vendor].BusUnitShortName) AS [Business Unit],
[Volume By BusUnit - Vendor].[Request Count]
FROM [Volume By BusUnit - Vendor]
GROUP BY [Volume By BusUnit - Vendor].FirstDayOfWeek,
[Volume By BusUnit - Vendor].[Request Count]
HAVING ((([Volume By BusUnit - Vendor].[Request Count]) In (select top 5
[Request Count] from [Volume By BusUnit - Vendor] I2 where [Volume By BusUnit
- Vendor].[FirstDayOfWeek] = I2.[FirstDayOfWeek] order by I2.[Request Count]
desc)))
ORDER BY [Volume By BusUnit - Vendor].FirstDayOfWeek,
[Volume By BusUnit - Vendor].[Request Count] DESC
Any help is appricated
I have been trying to find a fix for my problem with no luck. I am trying to
run a CrossTab query that is based on another nested query and I keep on
getting Error 3070. I don't have a parameter in any of my queries and I
changed the name of my fields so I am not useing a reserved word. The
followning is my Query:
TRANSFORM Count([Volume By BusUnit - Vendor Top BusUnit].[Request Count]) AS
[CountOfRequest Count]
SELECT [Volume By BusUnit - Vendor Top BusUnit].FirstDayOfWeek
FROM [Volume By BusUnit - Vendor Top BusUnit]
GROUP BY [Volume By BusUnit - Vendor Top BusUnit].FirstDayOfWeek
PIVOT [Volume By BusUnit - Vendor Top BusUnit].[Business Unit];
I am getting an error on [Volume By BusUnit - Vendor Top BusUnit].
FirstDayOfWeek
which is based on (This query runs without a problem) :
SELECT DISTINCT [ Volume By BusUnit - Vendor].FirstDayOfWeek,
Max([Volume By BusUnit - Vendor].BusUnitShortName) AS [Business Unit],
[Volume By BusUnit - Vendor].[Request Count]
FROM [Volume By BusUnit - Vendor]
GROUP BY [Volume By BusUnit - Vendor].FirstDayOfWeek,
[Volume By BusUnit - Vendor].[Request Count]
HAVING ((([Volume By BusUnit - Vendor].[Request Count]) In (select top 5
[Request Count] from [Volume By BusUnit - Vendor] I2 where [Volume By BusUnit
- Vendor].[FirstDayOfWeek] = I2.[FirstDayOfWeek] order by I2.[Request Count]
desc)))
ORDER BY [Volume By BusUnit - Vendor].FirstDayOfWeek,
[Volume By BusUnit - Vendor].[Request Count] DESC
Any help is appricated