Future Date

[jimihoffa]

Im working on a form for work .... I have limited Access experience BTW .... anyway, what I am trying to do is when an employee access a new form there is a field for Week End Date ---- is there anyway I can automaticlly populate this field with the end date given certain criteria. For example can I tell access .. if date() within data pool #(1, 2, 3, 4,.. 51, 52) select last date with in numbered data pool?

I have no idea if this can be done with in reason. Or even done period.

Thanks for your help in advance

 

[jimihoffa]

I know I can add dateadd (d,<<number of days forward>>, <<date to add to(ie. NOW for current date)>>)
so: dateadd (d,1,now) to make it show the date on the form as tomorrow.

What I need to know is how to tell it to check the date, realize its tuesday, wed, monday, whatever, and automaticlly populate this field with the end date of that week. Being friday of course.

Anyone have any ideas?