I am trying to create a query using VBA code to sperate the days worked by shifts.
i am using a combo list for the dates to be populated by a table and then i want to use a between criteria to sort the shifts (IE shift one is from 701 to 1500, Shift 2 is from 1501 to 2300 and so on)
i am...
better explaination
I will try to clear up some things here
First, some of this code is canabalized from an exaple i got online, hence the lstcounties. i just changed where the list box got its data and it worked.
there are 2 buttons because i was showing that i can get either the dates i want...
I am working on a DB that will help me sort data by dates and shift.
i can get the code to create the query to select multiple dates OR sort tby shift. I really need it to sort both with one button. i am sure this is easily done and i am just using the wrong code.
i have uploaded a sample with...