SQL qury works in access but not dreamweaver

[RayK]

I am using InterAKT dynamic charts extension to create a chart on a page. The
chart is to show number of meetings per month. The following SQL works in
Access...

SELECT DatePart("m",[Start]) AS MonthNo, MonthName(DatePart("m",[start]),True)
AS [Month], Count(Journal.Type) AS Meetings
FROM Journal
WHERE (((Journal.Type)="Meeting With Client"))
GROUP BY DatePart("m",[Start])
HAVING (((DatePart("m",[Start])) Between 1 And DatePart("m",Now())))
ORDER BY DatePart("m",[Start]);

However, in Dreamweaver when creating a recordset, I get an error
saying...'Undefined function MonthName in Expression'.

Can anyone tell me how to fix this?

Tahnks,

Ray Keattch

[Julian Roberts]

Certain functions available in Access are not available when using the Jet
engine. Use the Format() function instead, eg

Format([Date],'mmmm') AS [Month]

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[RayK]

I have put the format command around the items in the query but I am still getting the errors. Could you possible show me how my query should appear in Dreamweaver?

Thanks,

Ray Keattch.