Hi Lynn Pettis,

Yes I am using SQL 2008. Thank you in advance for your help.

Dear Luis C,

Thank you for providing me initial thought process, in this Query how to calculate hours for Mr. Patrick Liw and assumptions are every person will be on site...

Dear Jeff,

Yes this is for sure that Reader 26 and 27 are fixed for Ins and Out purpose.

Dear Lowell,

Thank you so much. This gives me good idea and after changing some Parameters, I am able to extract exact report.

Once again, Thank you!

Dear Chris,

Thanks for the prompt reply, apparently it seems to be perfect. Let me explore this in more details. Again Thank you very much.

Kind regards!

Dear Chris,

Thank you. Can you please give me example of below text.

Change the join column on my query to whichever MAX column fits your requirement.

Dear ChrisM / Dear Lowell,

Thanks for the prompt reply. I am really sorry about not able to communicate properly. So far I am unable to get required result.

I just need...

Thank you again Dave, this is Simple and Perfect Query and can easily caculate entire large rows.

Thanks Dave, its really help me a lot.

Dear Dave,

The said Query is Perfect for Single Stock No. For example as you used WHERE Clause for Stock No.(CT_STOCKNO_P='01-01-01-010') but when I remove this clause, same Min(TR_Date) and Max(TR_Date)...

Yes, I want four different results. For Example in attached Screenshot

The First "Issu" Transaction made on '2007-12-12'

The Last "Issu" Transaction made on '2011-02-26'

The First "PREC" Transaction made on '2007-07-28'

The Last...

Absolutely Right, but I am my Database is based on mySQL and I am new to mySQL and don't know coding. Your help will be highly appreciated!