Calculating time

[Dave]

I have a single table database that has a drop down box of 60 days, 90 days,
and 180 days.

I want to calculate to time from the date of entry in the database to count
down from the days that was selected in the drop down box.

How would I go about doing this please be detailed and if you can include a
simple of the code that I would need in order to complete the task.

 

[Jörn Bosse]

Am 03.06.2010 21:23, schrieb Dave:

I have a single table database that has a drop down box of 60 days, 90 days,
and 180 days.

I want to calculate to time from the date of entry in the database to count
down from the days that was selected in the drop down box.

How would I go about doing this please be detailed and if you can include a
simple of the code that I would need in order to complete the task.

Hi,

if you want to do so, you could use the DateAdd-Function.
I would use it in a query.
You have the fields: Date1,Interval,Date2 in your table1

And the query hast to look like this:
SELECT Table1.Date1, Table1.Interval,
DateAdd('d',table1.Interval,table1.Date2) AS Date2
FROM Tabelle1;

The 'd' is for the intervaltype - d for day
The 2nd operator is the intervall, hier you have to select your values
from the combo box
The last operator is the startdate.

Regards
Jörn

 

[John W. Vinson]

I have a single table database that has a drop down box of 60 days, 90 days,
and 180 days.

I want to calculate to time from the date of entry in the database to count
down from the days that was selected in the drop down box.

How would I go about doing this please be detailed and if you can include a
simple of the code that I would need in order to complete the task.

I suspect you'll use the DateDiff() function - press Ctrl-G to open the VBA
editor (to connect to the right Help file) and search for Help on DateDiff.

It's not clear to men what you mean by "count down". Do you want to calculate
the date 60 (or 90 or 180) days after the date in a date/time field in the
table? If so a Query with a calculated field

CountDownDate: DateAdd("d", [Forms]![YourForm]![YourDropdownBox], [datefield])

will do the job. If that's not what you want please post an explanation or an
example.