Date conversion problem

From within Access 97 (ideally in a query) I would like to convert a date in the format of year, week number and day number back into calendar date format.

e.g. Today is week 23, year 2001 day 4 which is 7/06/2001 (7th June 2001).

If it can’t be done in a query a VBA solution would be fine.

Thanks,

Ian