I have a table with a Date/Time field ("Date Added" ) in short date format (1/1/2011)
I want the user to open a report based on the month criteria selected with a list box.
Current list box columns:
Column 1 Column 2
1 January
2 February
3 March
Etc etc..
The report is based on a query with criteria in the "Date Added" column. I want the criteria to be whatever month the user selects.
The user wants to view total clients in Jefferson county who were added in the selected month.