I have a form that has seven checkboxes that representing everday of the week.
The user enters Start and End dates in addition to checking days of the week that Object a would occur in the start and end dates.
From access everything seems correct the data in table is correct. If user chooses SAT checkbox then SAT is stored this process continues accurately if user chooses 1, 2, or everyday of week.
But when that report gets exported to excel the days gets mixed up. What I notice occuring is if the user chooses SAT FRI is shown in excel and this is constant for everday of week selected once one day of the week is selected.
If SAT SUN FRI is selected then it is stored correctly in db but in excel spreadsheet THU SAT is populated.
If I choose every day of week then all days are stored in db correctly but in excel everyday of week is exported except for Fri
Please help I am at my ends wit.