only show this years results

[sdel_nevo]

Hi Guys

i have this query that creates a chart this works great and returns the total "issuesclosed" by month



SELECT (Format([IssueClosed],"mmm"" '""yy")) AS Expr1, Count(IssuesByAssetNameChart.NoteType) AS CountOfNoteType
FROM IssuesByAssetNameChart
GROUP BY (Format([IssueClosed],"mmm"" '""yy")), (Year([IssueClosed])*12+Month([IssueClosed])-1)
ORDER BY (Year([IssueClosed])*12+Month([IssueClosed])-1);


what i want to do is only show the current year, at the moment its showing all the months and years so for example i only want to show 2014's results and at the start of 2015 the chart will be blank

any ideas?

[pbaldy]

If you really mean the current year, add the bit in red:

SELECT (Format([IssueClosed],"mmm"" '""yy")) AS Expr1, Count(IssuesByAssetNameChart.NoteType) AS CountOfNoteType
FROM IssuesByAssetNameChart
WHERE Year(IssueClosed) = Year(Date())
GROUP BY (Format([IssueClosed],"mmm"" '""yy")), (Year([IssueClosed])*12+Month([IssueClosed])-1)
ORDER BY (Year([IssueClosed])*12+Month([IssueClosed])-1);

[sdel_nevo]

Hip baldy
Many thanks for the speedy reply I will update the query when I'm back in the office first thing in the morning

Many many thanks
Steve

[pbaldy]

No problem Steve.

[sdel_nevo]

Hi pbaldy

that worked really well, many many thanks

Steve