A
aemAndy
I have a crosstab query that calls on a query that calls on other queries...
you get the idea.
I'm getting the "the Microsoft Jet database engine does not recognize...."
- you know the rest.
Looking on these threads, everyone says "you must declare your paramenters"
when a crosstab call on a query. Fair enough.
But now, after using both the menus and straight SQL for "PARAMETERS"
declarations, I get prompts to manually enter values.
Clearly something is wrong...
First query:
SELECT [tblDistricts].[DistrictID], [tblSWLs]![FName] & " " &
[tblSWLs]![LName] AS SWL, 1+[tblSWLs]![PrimaryContact] AS xPrimme
FROM tblSWLs RIGHT JOIN (tblDistricts LEFT JOIN tblDistrictsandSWLs ON
[tblDistricts].[DistrictID]=[tblDistrictsandSWLs].[DistrictID]) ON
[tblSWLs].[PLID]=[tblDistrictsandSWLs].[PLID]
ORDER BY [tblDistricts].[DistrictID], 1+[tblSWLs]![PrimaryContact],
[tblSWLs]![FName] & " " & [tblSWLs]![LName];
Second Query:
SELECT [xqrySWL000].[DistrictID], [xqrySWL000].[SWL], (SELECT Count(*) FROM
xqrySWL000 As X WHERE (X.DistrictID=xqrySWL000.DistrictID) AND (( X.xPrimme
FROM xqrySWL000;
Crosstab query where I get the error -
TRANSFORM First(xqrySWL001.SWL) AS FirstOfSWL
SELECT xqrySWL001.DistrictID
FROM xqrySWL001
GROUP BY xqrySWL001.DistrictID
PIVOT xqrySWL001.Num;
Thanks in advance for any advice you may have.
you get the idea.
I'm getting the "the Microsoft Jet database engine does not recognize...."
- you know the rest.
Looking on these threads, everyone says "you must declare your paramenters"
when a crosstab call on a query. Fair enough.
But now, after using both the menus and straight SQL for "PARAMETERS"
declarations, I get prompts to manually enter values.
Clearly something is wrong...
First query:
SELECT [tblDistricts].[DistrictID], [tblSWLs]![FName] & " " &
[tblSWLs]![LName] AS SWL, 1+[tblSWLs]![PrimaryContact] AS xPrimme
FROM tblSWLs RIGHT JOIN (tblDistricts LEFT JOIN tblDistrictsandSWLs ON
[tblDistricts].[DistrictID]=[tblDistrictsandSWLs].[DistrictID]) ON
[tblSWLs].[PLID]=[tblDistrictsandSWLs].[PLID]
ORDER BY [tblDistricts].[DistrictID], 1+[tblSWLs]![PrimaryContact],
[tblSWLs]![FName] & " " & [tblSWLs]![LName];
Second Query:
SELECT [xqrySWL000].[DistrictID], [xqrySWL000].[SWL], (SELECT Count(*) FROM
xqrySWL000 As X WHERE (X.DistrictID=xqrySWL000.DistrictID) AND (( X.xPrimme
(xqrySWL000.SWL<=X.SWL)))+1) AS NumxqrySWL000.xPrimme) OR (( X.xPrimme = xqrySWL000.xPrimme) AND
FROM xqrySWL000;
Crosstab query where I get the error -
TRANSFORM First(xqrySWL001.SWL) AS FirstOfSWL
SELECT xqrySWL001.DistrictID
FROM xqrySWL001
GROUP BY xqrySWL001.DistrictID
PIVOT xqrySWL001.Num;
Thanks in advance for any advice you may have.