Just solved my problem. I used an expression in the field row of a query.

Excluded:IIf([SuspType]="In-School",DateAdd ("w",15,[ReturnDate]),IIf([SuspType]="Short",DateAd d("w",25,[ReturnDate]),IIf([SuspType]="Long",DateAdd ("w",50,[ReturnDate]))))

Thank you.

I think my code needs to be something like:

If Susp_Type = In-School then add 3 weeks to the return date and put the result in a field called excluded until
ElseIf Susp_Type = Short then add 5 weeks to the return date and put the result in a field called excluded until
ElseIf Susp_Type = Long then add 10 weeks to the return date and put the result in a field called excluded until
EndIF

I'm not sure...

I'm working on an access 2007 data base to track suspensions in a high school.

I need to calculate how long a student will be exlcuded from school activities depending upon the date they return from suspension and the type of suspension they were on.

I have a field for their return date and a field for the type of suspension - In-School, Short or Long. If a student was on In-School then they are excluded for 3 weeks...