Rewrite Crosstab Query

[georgesOne]

Dear All:
I have a webdb with two queries which are are obviously not web compatible (due to the first crosstab query):
1.

TRANSFORM Count(tblDHighLow.DHighLowID) AS DHighLowIDOfCount
SELECT tblDHighLow.Update, tblDHighLow.Division, tblDHighLow.Project
FROM tblDHighLow
GROUP BY tblDHighLow.Update, tblDHighLow.Division, tblDHighLow.Project, tblDHighLow.ProjectNo
ORDER BY tblDHighLow.ProjectNo
PIVOT tblDHighLow.Highlight;

2.

SELECT tblMreports.Update, tblMreports.Team, tblMreports.Project, 
[tblMreports].[DirHC]+[tblMreports].[InDirHC] AS HeadCount, 
qryDActSub.x AS Highlight, qryDActSub.[<>] AS Lowlight
FROM tblMreports LEFT JOIN qryDActSub ON (tblMreports.Project = qryDActSub.Project) 
AND (tblMreports.Update = qryDActSub.Update)
WHERE (((tblMreports.Update)=#2/20/2014#) 
AND ((tblMreports.Division)="ICM-L") AND ((tblMreports.Active)=True) AND ((tblMreports.Deleted)=False))
ORDER BY tblMreports.Update DESC , tblMreports.ProjectNo;

Is there any other way to generate a web compatible query?
Thanks for any hint, georges

 

[dhookom]

Why can't the second query be "web compatible"? If the first query is aryDActSub then there might be an issue but you don't say how the two are related.

Are there always a static list of possible Highlight values? For instance, if this was Months or Days, it would be static.

Duane
Hook'D on Access
MS Access MVP