How to get totals on report for a specified year

[gacapp]

Hello - not sure if this is in the right forum but if not, I will post in the appropriate one.

I have a report that feeds off a Sum Query. The query accumulates totals for various data for each month and then the report gives a total for all months, which includes multiple years.

So first of all, my queries data looks like this:



As you can see, there are totals for each month, starting in June 2015 thru February 2016.

Now my report looks like this:



As you can see the overall totals are at the bottom.

What I need is a way for the report to give the totals for just a single year - like 2015.

So how to I change the report to reflect the totals for just 2015? Is it a change in the report or the query it feeds off of?

If someone can help me and give and example, I would truly appreciate it. I'm not an expert in Access, so your patience is appreciated.

[CJ_London]

use a filter or criteria

where year(dateofvisit)=2015

note you do not really need the '201512' column - if required it would just be format(dateofvisit,"yyyymm")

[gacapp]

Again sorry but I am new to this and i still confused. Would the criteria go in the query that my report feeds off of or the report itself?

If it does go in the report, would I do this:

Go to the Properties of the report, go to the Data tab, go to the Filter line and put in: Where Year(Date_Of_Visit By MoYr)=2015

If anyone can help I would appreciate it