>Say for example one employee's entry and exit time may be multiple in a day
>that's
>why I need only one date and time column based on this i will do rest
>calculation.
>
>because i don't know how many times employee might have gone out side and
>again came in for the same day. >so, as per this i think one date and one
>time column is enough.

One date and one time?

Can you give sample data as to how you would like to calculate this then?

>Now as per following columns how i will calculate the total time employee
>had worked for a day (i.e. for each >day)
>
>1) EmpNo Varchar(15)
>2) dtDate Date
>3) tmTime Time

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com