Dlookup Function

[MarkHenderson]

Good Evening,

I am currently working with some data that is build in sequence with departure and arrival dates on each line, however I am looking to create a formula that will pull through the previous arrival date on to the line below, can anyone point me in the right direction :

Below is the date

Booking Number	From City	To City	Departure Date	Arrival Date	Expr1	Itinerary ID	Test Itinerary ID 1
8055623	London	Bangkok	01/12/2012	02/12/2012		1
8055623	Bangkok	Yangon	02/12/2012	02/12/2012	8.28363154406892E-05	2	1
8055623	Yangon	Bangkok	14/12/2012	14/12/2012	5.79854208084824E-04	3	2
8055623	Bangkok	London	15/12/2012	15/12/2012	6.21272365805169E-04	4	3

SELECT [Travel 2 - Flight Table 1].[Booking Number], [Travel 2 - Flight Table 1].[Test Itinerary ID 1], [Travel 2 - Flight Table 1].[To City], [Travel 2 - Flight Table 1].[From City], [Travel 2 - Flight Table 1].[Departure Date], [Travel 2 - Flight Table 1].[Arrival Date], DLookUp(CDate([Travel 2 - Flight Table 1]![Arrival Date]),"Travel 2 - Flight Table 1",[Travel 2 - Flight Table 1]![Test Itinerary ID 1] & [Travel 2 - Flight Table 1]![Test Itinerary ID 1]) AS Expr1, [Travel 2 - Flight Table 1].[Itinerary ID]
FROM [Travel 2 - Flight Table 1]
GROUP BY [Travel 2 - Flight Table 1].[Booking Number], [Travel 2 - Flight Table 1].[Test Itinerary ID 1], [Travel 2 - Flight Table 1].[To City], [Travel 2 - Flight Table 1].[From City], [Travel 2 - Flight Table 1].[Departure Date], [Travel 2 - Flight Table 1].[Arrival Date], [Travel 2 - Flight Table 1].[Itinerary ID]
ORDER BY [Travel 2 - Flight Table 1].[Booking Number];

[June7]

Review http://allenbrowne.com/subquery-01.html
especially the example 'Get the value in another record'