filter listbox of year to display all record of the current year and previous
I have a listbox that capture the years of hired date and displays it in horizontal view. So If you click on a year it will display all employee hired on that current year. But I want it to display all the employees of the current hire and the previous the years. Example is attached
Here's my code
Year(HireDate) as Year
Month(HireDat) as Month
From here I created two list box , one for Year and the other for Month.
Re: filter listbox of year to display all record of the current year and previous
I try to make a sample for your query..
What i understand from your question is that, when you select a year from the list box, you want to show the emp which are on that selected year and previous year of that selection.
for that purpose, i create two variables which are holding max(Year) and max(Year)-1. And by using the straight table, i write a set analysis to get the selected year and the previous year's list of employes.