This could be done; but it would take some work. Because the Mon, Tue, Wed, etc. would not be bound to the table at all. You would need VBA code to insert into the table and also to read from the table to display on the form.
Could you simply have them key the date or pick the date from a calendar and display the day name after the date is entered? You could make a report to display like you are asking.
Another option would be to add the Mon, Tue, Wed… fields to your table in place of the hours. The date field in the table would be the week beginning date that is created behind the screens on your form. Now the fields can be bound to the table. To calculate the actual date, you would use the dateadd function to add x number of days to the weekbeginning date.
Discuss This Question: 2  Replies