is this possible....

[fazer909]

up until now I have had no luck doing this but can anyone tell me if this is possible....

i managed to work out how many weeks trainees on my programme by using this query :

Week No: DateDiff("ww",[Start Date],Date())



my question is .... can i use the result from this expression to have information displayed from a particular field depending on which week they are on.. ?

e.g.

if a trainee is found to be on week 3 i would like it to display information from the 'week 3' field

i want to have 13 weeks worth of comments to display their progress on the programme and each week ill have to print off a report on how they are doing that week whilst keeping a record of this on the database

hope someone can help ?

[June7]

You have a 'week 3' field? Does this mean you have 13 'week' fields? This would not be a normalized data structure and will likely cause lots of frustration.

What you want could be done - with an expression or a custom VBA function.

Possible expression:

Choose(DateDiff("ww",[Start Date],Date()), [Week1], [Week2], [Week3], [Week4], [Week5], [Week6], [Week7], [Week8], [Week9], [Week10], [Week11], [Week12], [Week13])

[fazer909]

Exactly what i was looking for ..... thanks so much for your help .... you have made my day