<div>
Post a few exact scenarios, and the expected output for each...
</div>


Post a few exact scenarios, and the expected output for each...

<div>
Do you mean just Sunday or also Saturday?
</div>


Do you mean just Sunday or also Saturday?

<div>
Update mytable set datefield = datefield + iif(weekday(datefield)=1,0<wbr />, 8-weekday(daefield))
</div>


Update mytable set datefield = datefield + iif(weekday(datefield)=1,0, 8-weekday(daefield))

<div>
My suggestion above assumes that you take Monday as the start day of your week and Sunday as the last day of the week, and that you want to advance any non-Sunday date to the next Sunday that will occur.
</div>


My suggestion above assumes that you take Monday as the start day of your week and Sunday as the last day of the week, and that you want to advance any non-Sunday date to the next Sunday that will occur.

<div>
Thank you all for your contributions, this solution has achieved my goal :)
</div>


Thank you all for your contributions, this solution has achieved my goal :)

<div>
<div class="content wysiwyg-content">
hello, <br />
<br />
Does anybody know of a way to search for all dates in a specific column in an Access 2010 database and if they aren't a week end date (Sunday) then replace the value with the next sunday's date instead?<br />
<br />
I'm guessing it will be a hybrid of SQL and VBA to do this? <br />
<br />
Thanks <br />
<br />
Josh
</div>
</div>


hello, 

Does anybody know of a way to search for all dates in a specific column in an Access 2010 database and if they aren't a week end date (Sunday) then replace the value with the next sunday's date instead?

I'm guessing it will be a hybrid of SQL and VBA to do this? 

Thanks 

Josh

WeekEnd Date Updater

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.