From: ghetto_banjo on

That iif statement should be in the SET clause, not the WHERE

try this:

UPDATE Data SET Data.[Week Number] = IIf([Date of
Consent]<#12/21/2009#,DateDiff("ww",#12/21/2009#,[Date of Consent],
2),DateDiff("ww",#12/21/2009#,[Date of Consent],2)+1) WHERE data.[Date
of Consent] Is Not Null;

From: SamMexico via on
That worked brilliantly - that is my reporting problem solved! Thank you
again for all your help and patience!

Message posted via

From: ghetto_banjo on
you're welcome. glad to help.