Help with a field calculation please

Hi,



I have a database with fields called:



Date Raised (Date which defaults to todays date)

Target Closure Date (Date calculated)

Priority_2 (Tick box)



Currently the Target Closure Date is automatically calculated by an entry in the default value on the form which reads [Date Raised] +5 and this works fine.



I've been asked to add a formula in so if Priority_2 is ticked then the Target Closure Date = Date Raised +1 day. If Priority_2 is not ticked then the Target Closure Date = Date Raised + 5 days.



I'm struggling with this; my Access experience isn't brilliant so please be gentle with me :-)



Stu

Help with a field calculation please