Please be gentle as I'm new to this Access lark!!
: Please be gentle as I'm new to this Access lark!!
Use the DateAdd() function. DateAdd has the following parameters: Interval - yyyy, m, d Number - number of intervals to add Date - date to which the interval is added
If you wanted to add 3 months to May 5, 1999,you would use the following:
DateAdd("m", 3, #5/4/99#)
It looks like you're new here. If you want to get involved, click one of these buttons!