Hi,
Can someone point me in the best direction to go for entering data to a table - the image is from excel.
The user performs each activity for 3 or 4 weeks and then changes activity.
I want to be able to update the table for the 4 week period.
i.e. user 'A' does activity 'Y' on weeks 9,10,11,12.
This is just a small sample, there are over 140 users on the full table.
I was also going to incorporate a crosstab query in the form with ACTIVITY as Row Headings, USER as Column Headings and WEEK as the lookup to track which User has completed each activity.
Many Thanks.