G
Guest
Have a query criteria to find all employees that have a hire-date anniversary
based on the month selected. Obviously there are various hire days and
years....which isn't important...just trying to find everyone's anniversary
by the month.
In the table the hire dates are stored 1/1/2005 etc.
I can manually put in criteria of: Like "3/*/*" and it correctly returns
all employees with a hire date in March month 3
In the Form there is a simple listbox of all Months with first column number
1 to 12 which is bound.
I want the month number selected in the listbox to appear in the query
criteria.
So have attempted the query criteria:
Like "&[Forms]![A-SelectMonthForm].[MonthListbox]&/*/*"
Like "[Forms]![A-SelectMonthForm].[MonthListbox]/*/*"
Like "[Forms!A-SelectMonthForm.MonthListbox]/*/*"
not working.....what am I missing??
based on the month selected. Obviously there are various hire days and
years....which isn't important...just trying to find everyone's anniversary
by the month.
In the table the hire dates are stored 1/1/2005 etc.
I can manually put in criteria of: Like "3/*/*" and it correctly returns
all employees with a hire date in March month 3
In the Form there is a simple listbox of all Months with first column number
1 to 12 which is bound.
I want the month number selected in the listbox to appear in the query
criteria.
So have attempted the query criteria:
Like "&[Forms]![A-SelectMonthForm].[MonthListbox]&/*/*"
Like "[Forms]![A-SelectMonthForm].[MonthListbox]/*/*"
Like "[Forms!A-SelectMonthForm.MonthListbox]/*/*"
not working.....what am I missing??