Monthly Report based on Annual Date!!!!

[Kckronic21]

I have a problem. I have a table called “Employee” The fields in that table are: “Last_Name”, “First_Name”, “Date_of_Hire”, “Center”,“Position”, “Promoted”, and “Promoted_Date”. I have created a Form called “Annual_Form” and I have created a combo box that list all of the “Centers” and a combo box that list all of the “Months” of the year. I want to set up a monthly report that shows all Employees by their “Center”. For Example: If “employee A” was hired on 5/6/01, I want that person to show up in the May report. If “employee B” was hired on 7/04/98 and promoted on 8/9/01, I want that person to only show up in the August report and not in the July report. Thanks!

 

[ChrisBelzona]

Kckronic21

An IIf statement may do the trick, in your report record source create a column as follows,
Expr1: IIf(Not IsNull([Promoted_Date]),Month([Promoted_Date]),Month([Date_Of_Hire]))

So what where saying here is
If there is no Promoted date then show the month only for The Date of Hire else display the month of Promotion

You should then be able to set the Criteria for the month of your choice.

Hope that works or makes sence if not I'll try it again.

Good luck

Chris