Pardon my ignorance but is there any easy way to pull information out of a table in Eastern Standard Timen that is currently stored using a different time zone. Any suggestions would be appreciated.

Rd

--
Message posted via http://www.accessmonster.com

If you know the difference in hours between the time zones, use the DateAdd
function to get the other time zone time from EST.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource (AT) pcdatasheet (DOT) com
www.pcdatasheet.com


"Ranald Davidson via AccessMonster.com" <forum (AT) AccessMonster (DOT) com> wrote in
message news:3aa728ab081f40e5a52353dc1cbb67df (AT) AccessMonster (DOT) com...
time zone. Any suggestions would be appreciated.

Thx will give it a go

--
Message posted via http://www.accessmonster.com

thanks.... but seem to be having problems with the syntax of the function. I am trying to create a ref table with time zones and time differences. This table with have a number that will represent the difference in time from the actual data and the result i need to get.

Rd

--
Message posted via http://www.accessmonster.com

You need two tables like this:
TblTimeZone
TimeZoneID
TimeZone

TblTimeDifference
TimeDifferenceID
TimeZoneID
TimeDifference

TimeDifference is the number of hours difference between the TimeZone
represented by TimeZoneID and EST.

In a form you would have a combobox based on TblTimeZone to select the time
zone and a textbox to enter the time. There would be another textbox to
display the time converted to EST. The control source of this textbox would
be:
=[NameOfTimeTextBox] +
DLookup("[TimeDifference]","TblTimeDifference","[TimeZoneID] = " &
Forms!NameOfYourForm!NameOfTheCombobox)

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource (AT) pcdatasheet (DOT) com
www.pcdatasheet.com


"Ranald Davidson via AccessMonster.com" <forum (AT) AccessMonster (DOT) com> wrote in
message news:f5d9c135c22d46a19292d7428111400a (AT) AccessMonster (DOT) com...
differences. This table with have a number that will represent the
difference in time from the actual data and the result i need to get.