Display Week

[Kirstie Adam]

All,

I have a date column [Date of Visit] and i want to be able to enter the
date, and then have that populate antoher field [Week of Visit].
e.g - Date of Visit is 14/07/2003
then
Week of Visit is 29

Can anyone help?

Thanks

Kirstie

 

[Neil]

Kirstie,

Set the properties of the Week of Visit text box as follows:

Format: ww
Control Source: =[Date of Visit]

HTH,

Neil.