I am trying to figure out how to create a drop down list of weeks, instead of a specific day in the week.
I want to use the drop down in a form for running a select statement based on the week selected in the drop down.
My field in the database table is formated as specific dates (ex. 27-Apr-2005).
So, when the query runs I want the recordset to be the week of records based on what week the user chose in the drop down list.
Any examples would be most appreciated.