Date Calculation based on different frequency in a Query.

[rntjagdeo]

Hello Access Guru,
I would appreciate kindly if someone can help me with a Query. I would like to run a Query that would have the following Columns from a Table.
NAME : COURSE ; FREQUENCY : DATE COMPLETED : DUE DATE.
The DUE DATE is to be a calculated field based on DATE COMPLETED and FREQUENCY.


The FREQUENCY ranges from: Once, Yearly, Six Months, and 3 Years depending on the course.
I am new to fairly new to access and would appreciate step by step information.
Thank you very, very much for your assistance.

[ranman256]

You didnt provide much info for the calcs...but
You really need a query to covert [frequency] to a uniform unit of measure..say D for days, M for months
and you need the Amt of days

once = 1 ?
yearly = 1 UOM = Y
6mos = 6 UOM = M
???

then the 2nd query would be:
DUEDATE: Dateadd([UOM], [DayAmt], [dateCompleted])

[rntjagdeo]

Thanks ranman256,
I convert all frequency to days and it worked beautifully.