A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Calculating time



 
 
Thread Tools Display Modes
  #1  
Old June 3rd, 2010, 08:23 PM posted to microsoft.public.access
Dave
external usenet poster
 
Posts: 2,331
Default 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  
Old June 3rd, 2010, 09:40 PM posted to microsoft.public.access
Jörn Bosse[_3_]
external usenet poster
 
Posts: 20
Default 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  
Old June 3rd, 2010, 09:48 PM posted to microsoft.public.access
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:14 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.