97 to XP conversion SQL problem

[Trebor100]

Hi all,

The following SQL query works a-okay on 97 but does not work on XP. The problem is on the Format function which is not recognised in XP however its removal causes the query to return no current record. Any help would be much appriciated.

TRANSFORM Count(Query1.ApplicationID) AS CountOfApplicationID
SELECT Schools.SchoolID, Query1.From, Query1.To
FROM Query1 RIGHT JOIN Schools ON Query1.SchoolID = Schools.SchoolID
GROUP BY Schools.SchoolID, Query1.From, Query1.To
PIVOT Format([Available],"Yes/No") In ("Yes","No");

 

[PHV]

And what about this ?
PIVOT IIf([Available],'Yes','No')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886