the following executed perfectly....! thanks everybody helped me in the context....thanks once again.. expecially xnthos...

DateDiff("n",[Table1]![in_time],[Table1]![out_time])

+ IIf(DateDiff("n",[Table1]![in_time],[Table1]![out_time])<0,24*60,0)

b rgds

sunil joshi (9930580082) (Mumbai, India)

I wanted to calrify more that

the "TimeSheet.txt" file is "Comma" delimited file and having following data for e.g.

Text File : TimeSheet.txt (first row are the field names I have taken...

Thanks everybody for the prompt help. it will definatly helped me a lot.

However, Please note that the text file format is having separate columns for "attendance date", "In Time" and...