Date Filter for Reports, I Need Help?

[ANDREW]

I actually have two questions
Question #1: I have created a report that list multiple years worth of information. I need to be able to Filter only the year I want. I would like a box to appear and ask me "For what Year do you want this Report?" I should be able to input the year, and the only data a get is for the year I request.

Question #2: I need to do a Count expression. I have another DB that lists training for my employees. One of my fields shows if they were "Present" or "Not Present". I need to be able to count a text field to be able to tally the total number of "Present" in the year.

Any Help would be greatly appreciated. Thanks

 

[dennyryan]

1. Set up a calculated field in yur query

Year: Year(datefield)

enter the paramater prompt under this field.

2. Set up a calculated field in your query

PresentCount: iif(PresentField = "Present",1,0)

sum this guy and you'll have your count.

Denny