Due date calculation

[globalsourcing]

i have a column name "Last paid date" in my table payments.i want to calculate due dates based on the below condition.
1. if "frequency' column = monthly add one month in last paid date.

2.if "frequency' column = qtrly add three month in last paid date.

3.if "frequency' column = semiannually add six month in last paid date.

4.if "frequency' column = annually add 12 month in last paid date.

[dflak]

Assuming Cell A2 has the date and B2 has the frequency:

Please Login or Register  to view this content.

[Arkadi]

SQL:

Please Login or Register  to view this content.

Query Designer:

Please Login or Register  to view this content.