Dsumlookup

[KirkComer]

I am trying to get a end date based off of a next row in sequence for each person by job in my query. My query results keep repeating the same end dates for eack of my persons jobs.

I think the attached picture and database will make things pretty clear.

Please let me know if I haven't explained things very clearly.

Here is the formula I am curently using.
end date: DLookUp("[start date]","tbl_dates","[sequence number]=" & [sequence number]+1)

Thanks in advance!,
Kirk

 

[khawar]

Download the attached file I have modified your query

 

[KirkComer]

Thanks but I could not open up the attachment.

 

[KirkComer]

khawer... I just figured out that I had to change the filename extension. duh

Thank you so much. It works wonderful!!