surreal1780

Hi All,
I'm still learning the ropes of Access as a relatively new user. Could someone help me with writing an expression for an "if or and" function in conjunction with a calculating a future date function? This is what I have so far, but can't get it to work:

=IIf(IsNull([Pre-assessment 2 Date - Control Starts]), DateSerial(Year([Pre-assessment 1 Date - Immediate starts]),Month([Pre-assessment 1 Date - Immediate starts]),Day([Pre-assessment 1 Date - Immediate starts])+49)


This function would concern 3 fields: "Pre-assessment 1 Date - Immediate starts", "Pre-assessment 2 Date - Control Starts", and "Date of Week 7 Post-Assessments"

The function I was attempting to create would do the following:

If the "Pre-assessment 2 Date - Control Starts" field DOES NOT have a date entered in, then "Date of Week 7 Post-Assessments" would equal a date 7 weeks later from the date listed in "Pre-assessment 1 Date - Immediate starts".

Or

If "Pre-assessment 2 Date - Control Starts" DOES have a date, I would like "Date of Week 7 Post-Assessments" to equal 7 weeks later from the date listed in "Pre-assessment 2 Date - Control Starts".

I'm assuming this function would be embedded within the "Date of Week 7 Post-Assessments" field

Many thanks in advance,
Dan