Results 1 to 1 of 1

Thread: Time Format in DataGrid Problem

  1. Jun 5th, 2003, 01:32 PM #1
    gertdu
    gertdu is offline

    Thread Starter
    New Member
    Join Date
    Jun 2003
    Location
    South Africa
    Posts
    1

    Question Time Format in DataGrid Problem

    I am using VB6 and Microsoft Access and got the following problem:

    I populate a DataGrid with a SQL statement as follows:

    Adodc1.RecordSource = "SELECT MonthOfYear AS Month, SUM(Time) AS [Total Time] FROM Table GROUP BY MonthOfYear"

    When the statement execute for ex: 13:00:00 + 13:00:00 it gives an answer of 1.08333 which is correct. My problem is when I add the following statement.

    DataGrid.Columns(1).NumberFormat = "hh:mm:ss"

    It converts the answer to 02:00:00 but I want the answer to be displayed as 26:00:00 any suggestion would be appreciated to stop the formatting part from discards the whole day part.

    Thanks
    Last edited by gertdu; Jun 5th, 2003 at 01:43 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width