Re: How convert GMT to LocalTime in Access 2003

Hi -

See:
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=55810

HTH - Bob

Anita Tadhani wrote:
I have Access 2003 database stores Time in GMT. I want to convert this GMT
time into localtime when I display in Report.
How should I write the query?
Thanks

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

.

Relevant Pages

  • Re: Dynamic Reporting based on Parameterized Crosstab Query
    ... The tek-tips solution does display the actual date on the report. ... on the first 3 rowwise fields of the crosstab query. ...
    (microsoft.public.access.reports)
  • Re: Page totals error in report - doesnt add correctly
    ... display it on a form or report. ... query based on the Import Table. ... All Totals text boxes properties are set to General number with 2 decimal ...
    (microsoft.public.access.reports)
  • RE: creating a query for a report
    ... I need to form it into a query that will display the following ... > line name, client name, prospect name, etc. ... The header of the report and the body of the report must be displayed in the ...
    (microsoft.public.access.queries)
  • Re: missing field data in several records in a report
    ... Is there something different about the properties of the report controls ... that DO display their data, when compared with those that DON'T? ... > and the query returns all the required fields when run, ... > "Jeff Boyce" wrote: ...
    (microsoft.public.access.reports)
  • Re: Query Problem - Leaving out Records
    ... >main report. ... >> My query is working fine, ... >> One idea I have is to display what my query is ... >> DUMBY part. ...
    (microsoft.public.access.queries)