I have a table of employees which includes a field named HireDate. I have a combo box with a list of months, and a command button. I want to create a query that will select all employees hired in the month selected from the combo box.
I have a table of employees which includes a field named HireDate. I have a combo box with a list of months, and a command button. I want to create a query that will select all employees hired in the month selected from the combo box.
Hopefully your combo would have two columns.
The first would be the Month number and the second the Month Name.
So your criteria would be Forms!YourForname!YourComboName against the Month() function on your hiredate. That would give you those for this year, last year and the year before that etc etc?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Maybe also include the year in your query?
Thanks, I think that will work.
No, just the month name. I just received a solution. Thanks for your quick reply.