Recent content by ivyjoe

I want to first thank you for the great help. It feels like we are very close, then only issue is the lapsed time calculation. The attached .xls file has a tab labeled "detailed output" (see col. K for a manual calculation that I added -- row's 503-506), and the tab labeled "new sql query...

Thanks for the feedback. I have attached a file that depicts both the detailed records and a summary tab of how I would like have the final data output. The table names are on top of each tab on the attached .xls file. Overall, I am looking for a summary by date, by person, by transaction...

I have a AS400 database table that stores time in the following manner 70535 (hour, minutes, seconds). Utilizing access 2010, I have used the left, mid, and right command to separate hour, minute, and second into their are separate table values 7 05 35. The AS400 database stores 3:15:30pm in the...

Hello everyone...