I have dug deep into the forums but unfortunately can not find a previous post that pertains to this question.
I have a date field in my Expenses table. It is in the format mm/dd/yyyy. I need to search this table for all records in any given month and year.
I have a form with 3 combo boxes. The first one selects the employees name, the second selects the numerical month (1-12), and the last selects the year.
I wish to be able to select the criteria on the form and then open the report based in this criteria.
However I can't seem to be able to find the proper syntax to tell the query to look at Combo box 2 for the month and combo box 3 for the year. Is this even possible?
Any help would be greatly appreciated.
I have a date field in my Expenses table. It is in the format mm/dd/yyyy. I need to search this table for all records in any given month and year.
I have a form with 3 combo boxes. The first one selects the employees name, the second selects the numerical month (1-12), and the last selects the year.
I wish to be able to select the criteria on the form and then open the report based in this criteria.
However I can't seem to be able to find the proper syntax to tell the query to look at Combo box 2 for the month and combo box 3 for the year. Is this even possible?
Any help would be greatly appreciated.