Test Date x Freq

[HL]

Hi

I have a form with 2 dates and a combo box showing the test frequency.

Test date, frequency (6, 12, 18 24 months) and the retest date.

I want to make a query to return the value after I have picked the test freq. How to do it?

For instance, if I enter 01/01/04 and select the value 18 months the query should return the date 01/06/06.

I know that I have to use unbound text box to show the retest result.

Thanks in advance

 

[sfreeman@co.mer]

Try something like....

SELECT
tblRetest.TestDate
, tblRetest.Frequency
, DateAdd("m",[frequency],[testdate])

AS
RetestDate

FROM
tblRetest;


HTH