MS Access Report Problem.


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: MS Access Report Problem.

  1. #1
    Join Date
    Jun 2005
    Posts
    1

    MS Access Report Problem.

    Dear Friends,

    I have a report in MS Access, in which I have four cols.

    EmployeeID TimeIn TimeOut Late
    1234 09:10:00 18:00 09:10:00 - 09:00:00

    My problem is on the fourth column I must have an expression or formula
    which allows me to calculate the difference of Time from the the TimeIn i.e
    09:10:00 - 09:00:00, How I can create a formulate which allows me to do so in MS Access?

    I know how to do in Excel and Crystal Reports but not very much familler with MS Access Reporting..

    Can anybody help me?

    Thanks.

    Imran Jalali.

  2. #2
    Join Date
    Jun 2005
    Posts
    5

    Access Report

    hello

    try : DateDiff("h";[in];[out]) & ":" & (DateDiff("n";[in];[out]) Mod 60) & ":" & (DateDiff("s";[in];[out]) Mod 3600 Mod 60)


    in and out are Date/time formated

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center