Weird Date Calculation

[Naka]

im absolutely terrible at vba and module developing and stuff like that. so im asking if someone could write a code for me that does the following:

Takes a date from a field in a table, then if that date is a Monday or a Tuesday, it will subtract 11 days from it. And if that date is a Wednesday/Thursday/Friday, then it will subtract 9 days from it.

Thanks

 

[Brianwarnock]

Well now you wont improve if somebody does it all for you. This is a simple use of the Case statement like so

Select Case Weekday(Me.flddate)
Case 2, 3
Me.Text3 = Me.flddate - 11
etc
Case Else
what are you going to do here?
End Select

Brian