It might make more sense to introduce another couple of tables in there for
time zone. (It's a many-to-many between time zone and country,
unfortunately).
Once you know the time zone, the offset to UTC is actually in the registry
(in HKLM\Software\Microsoft\Windows NT\CurrentVersion\TimeZones)
Randy Birch has several examples of how to deal with time zone information
at
http://vbnet.mvps.org/code/locale/index.html (Obligatory Warning: Randy's
site is aimed at VB programmers. Since there are signficant differences
between the controls available for forms in VB and in Access, some of his
examples will not port into Access without some tinkering)
Another possibility that just occurred to me is to download the sample
database Pedro Gil provided to "The Access Web". You can find it at
http://www.mvps.org/access/forms/frm0051.htm
--
Doug Steele, Microsoft Access MVP
(no private e-mails, please)