<div>
Hi,<br />
<br />
pls refer to<br />
<br />
<a href="http://www.cpearson.com/excel/LocalAndGMTTimes.htm" rel="ugc">http://www.cpearson.com/excel/LocalAndGMTTimes.htm</a><br />
<br />
Regards
</div>


Hi,

pls refer to

http://www.cpearson.com/excel/LocalAndGMTTimes.htm [http://www.cpearson.com/excel/LocalAndGMTTimes.htm]

Regards

<div>
...So implementing default value as zulu time is not possible, since all this is code values.
</div>


...So implementing default value as zulu time is not possible, since all this is code values.

<div>
I don't think you want to Change all Computer times to Zulu<br />
<br />
<br />
<a href="http://support.microsoft.com/kb/221542" rel="ugc nofollow">http://support.microsoft.com/kb/221542</a>
</div>


I don't think you want to Change all Computer times to Zulu


http://support.microsoft.com/kb/221542 [http://support.microsoft.com/kb/221542]

<div>
No, I want to have the default value of an access field report as ZULU.<br />
<br />
The excel example doesn't show how to do that.
</div>


No, I want to have the default value of an access field report as ZULU.

The excel example doesn't show how to do that.

<div>
I made a little database to convert times from one time zone to another a while back; it might be helpful here:<br />
<br />
<a href="http://www.helenfeddema.com/Files/accarch121.zip" rel="ugc">http://www.helenfeddema.com/Files/accarch121.zip</a>
</div>


I made a little database to convert times from one time zone to another a while back; it might be helpful here:

http://www.helenfeddema.com/Files/accarch121.zip [http://www.helenfeddema.com/Files/accarch121.zip]

<div>
<div class="content wysiwyg-content">
I have an application dealing with air travel, and all times use GMT, or ZULU time.<br />
<br />
Is there a way to autopopulate a date and time field to utilze ZULU, or GMT as a default value?<br />
<br />
My end goal is to have the member type an entry on a form in the &quot;Item&quot; field, and have the date and time fields autopopulate with the Zulu time and date.<br />
<br />
Database will be used from within several time zones, too.<br />
<br />
Time and Date are separate fields.
</div>
</div>


I have an application dealing with air travel, and all times use GMT, or ZULU time.

Is there a way to autopopulate a date and time field to utilze ZULU, or GMT as a default value?

My end goal is to have the member type an entry on a form in the "Item" field, and have the date and time fields autopopulate with the Zulu time and date.

Database will be used from within several time zones, too.

Time and Date are separate fields.

Automatically select zulu time

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.