pick list of sorts (1 Viewer)

[mark curtis]

Dear all,

I am having a slight problem

I have a scenario where a user has to allocate a task to be done on a monthly cycle a set number of weeks in that month.

Therefore every month has four weeks and if the task needs to be done on week 1,2 &4 thus omitting three I need to allow a user to select the weeks that this task is to commence and then store a ref to each week.

Thanks
Mark

 

[rockman]

My answer (if I have your question right) would be the creation of 4 Yes/No fields in the Users table indicating whether that User had required tasks during which week. You could also have a single text field and fill it with the week numbers (e.g. "124") this would demand some parsing of the string and therefore is not my preferred approach.

The more difficult question (in my eyes) is how do you define week 1, week 2, etc. If August 1 is on a Thursday, is that week, week 1 or is the next full week, week 1. Or is week 1 from Thursday to Thursday?

Jeff