You are amazing Scott!  Thank you so much!

I think this will work.  I have NOT yet adjusted it for performance (or tuned it at all yet, really), I was just trying to make it work.  Let...

Thank you Ken.  This script works like a charm!  You rock!

Thank you ScottPletcher.  You are awesome!   I will need to spend some time figuring out how you do this.

Performance does not matter in my case since I am only dealing...

Sorry, I am really new to SQL.  If you can give me a TSQL that can produce the output format I need from my provided sample data, I would be...

I really do appreciate your comment and spending the time to explain about proper database design and industry best practices.

Maybe I should have spent more time explaining the background of...

no, not html format.  As long as the query result is the same as what's in the picture, I am good.

Thank you so much for the query and it worked flawlessly. However, is there another way to get the same results faster? My data set has 20 millions...

Mark, you are AWESOME!!

Thank you very much for your quick reply.

In Access, the field Data Type is "Date/Time"

To...

Welsh Corgi (12/3/2011)

MS Access can retrieve and measure time with millisecond precision, but only with the help of a few well-known API calls and several...