Prev: Need to migrate phone no into the next record if the family
Next: Average interpurchase times
From: ghetto_banjo on 15 Apr 2010 08:35

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

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 AccessMonster.com on 15 Apr 2010 09:07
That worked brilliantly - that is my reporting problem solved! Thank you
again for all your help and patience!

--
Message posted via http://www.accessmonster.com

From: ghetto_banjo on 15 Apr 2010 09:31
you're welcome. glad to help.
First  |  Prev  | 
Pages: 1 2 3
Prev: Need to migrate phone no into the next record if the family
Next: Average interpurchase times