I recently got some very useful and precise help from these forums...that worked well. So I figured I'd cast my line out here first. I do not know the best way or rather most effecient way to go about an issue that I have come across. It relates to the help that I recently got but here is the basis.
I have a table that has this information
Date | Name | Start_Time | Event
There are a bunch of queries that i've had to set up, and there is one that I do not know if it is even possible or what I will have to do to get it to work. But it goes something like this. I need the next Start_Time for the direct chronologically next event, in a seperate Column with no Date carryover, and no person carryover. So at each change in Date and/or Name, do not record the next start_time.
Date | Name | Start_Time | Next_Start_Time | Event