Year only field

[tjones]

What criteria should i use to look for transactions for whole year of ? and repeat the data for every year there is an entry. The Year field is set with just a year and not the entire date.

 

[vbaInet]

I don't understand your question. Isn't it a matter of putting the corresponding year number in the Criteria row under the Year field? Or if you want non Nulls put Not Is Null there instead. Or do you mean something different?

 

[tjones]

I am trying to build a report that looks like this. I need it to go through each year for each type and put the total per year for each type degree and then what % (there is a field to track this) and then the totals based on the information above.

It need to track only "graduated" and not any other type status.

 

[vbaInet]

I also need to see what your records look like.