If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
The Microsoft Jet database engine does not recognise...
Hi everyone,
I've been helped out on here and managed to get a query working exactly how I wanted although now I can't seem to generate a chart from said query. The query below shows the cumulative values over paticular regions: SELECT Format([Date of Consent],"mmm yyyy") AS Month_Year, Data.Region, Count (Data.[Date of Consent]) AS CountMonthYear, (SELECT Count([XX].[Date of Consent]) FROM Data AS [XX] WHERE Format([XX].[Date of Consent],"yyyymm") =Format([Data].[Date of Consent],"yyyymm")) AS Cumulative FROM Data WHERE (((Data.Region) In ("Leicester","Nottingham","Northampton","Kettering ", "Derby"))) GROUP BY Format([Date of Consent],"mmm yyyy"), Data.Region, Format([Date of Consent],"yyyymm") HAVING (((Count(Data.[Date of Consent]))0) AND (((SELECT Count([XX].[Date of Consent]) FROM Data AS [XX] WHERE Format([XX].[Date of Consent],"yyyymm") =Format([Data].[Date of Consent],"yyyymm")))0)) ORDER BY Format([Date of Consent],"yyyymm"); But when I create the chart I get this error message: 'The Microsoft Jet database engine does not recognise '[Data].[Date of Consent]' as a valid field name or expression''. I believe thi shas something to do with the query parameters if searching on here is anything to go by but I'm a novice and need it spelled out ot me. If anyone could help that would be great Sam -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|