If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Calculating time
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. |
#2
|
|||
|
|||
Calculating time
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 |
#3
|
|||
|
|||
Calculating time
On Thu, 3 Jun 2010 12:23:06 -0700, Dave
wrote: 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|