Calculate Due date based on drop down list

[Back2Basics]

Hi



I am trying to calculate the due date for a project based on the start date and the project type. I have a table with project type, days, months - for each project type there are associated days and months which I would like to add to the start date to provide the expected due date.

The field names I have are:
Project type = [Application Type]
Start date = [Date Duly Made]

I also need to add a month if the project needs consultation, which is a tick box on a form.

For example:

Date duly made = 01/02/2015; Application Type; Type 1 - this means it will take 3 months and 0 days; No consultation
The Due date should be = 01/05/2015

Date duly made = 01/02/2015; Application Type; Type 2 - this means it will take 0 months and 28 days; Consultation Required
The Due date should be = 28/03/2015

Any help with this would be really really appreciated

NB. I haven't built this database, I've just be charged with updating it.

[CJ_London]

if your dropdown (we'll call it cboProjectTypes) rowsource is something like

SELECT ProjectType, NoDays, NoMonths FROM tblProjectTypes

and you have set no of columns to 3

and your consultation tick box is called hasConsultation

then your calculation for due date would be

dateadd("d",cboProjectTypes.Column(1)+(abs(hasCons ultation)*28),dateadd("m",cboProjectTypes.Column(2 ),[Date Duly Made]))

[Back2Basics]

Brill

thanks Ajax