query SQL error

[jscriptor09]

Hi folks



Any idea what is wrong with this sql statement?

"SELECT MAX('CountOfThroughPutDate_FW') AS theCount FROM (SELECT ThroughPutTable_Generic.ThroughPutDate_FW, Count(ThroughPutTable_Generic.ThroughPutDate_FW) AS CountOfThroughPutDate_FW FROM ThroughPutTable_Generic GROUP BY ThroughPutTable_Generic.ThroughPutDate_FW
"

Access complains about the first FROM.

This part
"(SELECT ThroughPutTable_Generic.ThroughPutDate_FW, Count(ThroughPutTable_Generic.ThroughPutDate_FW) AS CountOfThroughPutDate_FW FROM ThroughPutTable_Generic GROUP BY ThroughPutTable_Generic.ThroughPutDate_FW
"

Works fine.

What I am trying to do is get a 2 col recordset and then get the max value from one of the columns.

Thanks
Mike

[orange]

Try it without the single quotes here
SELECT MAX('CountOfThroughPutDate_FW')