Calculate Start/End from just Start

[Guest]

My DB has an Assignmenet table that captures the date/time a record was
assigned to a team.
Records may be reassigned to other teams once or many times.
How do I create a query that returns the start and end date/time for each
team.
Assuming the end date/time for one team is the start date/time for the next
team.
E.g. (ignoring times)
Team A 1/1/07
Team B 2/1/07
Team C 7/10/07
should translate to:
Team A 1/1/07 2/1/07
Team B 2/1/07 7/10/07
Team C 7/10/07 Null

 

[Allen Browne]

Use a subquery to get the "next" record for the team, and then DateDiff() to
calculate the difference in miNutes.

Subquery example:
http://allenbrowne.com/subquery-01.html#AnotherRecord