Hi all,

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.

Hi there,

Need to know two things to be able to help:

1. How is the data stored in Access? You have start and end dates and some weekdays checked. What fields are
in the table?

2. What method are you using to export to Excel? You mention a report being exported. Are the tables or are
reports based on the tables being exported?