Problem in creating "Report" through query

[zonexs123]

Dear All,
I am developing an access based report, but I am stuck with some issue.
a) In my query “qryreportsTA” I want to have a month column as per received date. Its easy to do in excel (sample sheet attached) however not able to do in query.
b) I am not able to create a report in access as shown in screen-shot (attached) as per selection done through form “frmReportsTA”. Every time I have to export into excel, do the pivot table to view counts.
Appreciate if anyone can help me out to solve my above two problem.

Thanks in advance guys J

 

[zonexs123]

Hi Experts,

Could you please help me out in solving above problem. I am unable to create Report as shown in screenshot attached. It would be great helpful !!!

Many Thanks,
Santosh

 

[CBrighton]

a) Month([FieldName]) will give the month from a date, though it will be the number. You may be able to do a custom format though, something like:

Format([FieldName],"mmm")

b) Looks like you want a crosstab query.

Sadly I hate them and have only used them about once. However a search for "crosstab query" should give you plenty of info if no one else finds this thread.

 

[zonexs123]

Thanks a lot. However I try to figure out through Crosstab Query but failed. Could you please advise me what would be the easiest way to create a report look like what I had shown in the screenshot.

I hope there would be some other way around to solve this problem. Please Advise !!!