DLookup - Finding matches of two fields of different records and grouping results...?

[luvgis]

Hi All,

I am fairly new to Access and the forums but I would appreciate any insight into this question of mine...

I am working with transportation data and I have a series of trips each with a unique trip idea. The trips all have a "Start_Plac e" and "End_Place" (the geographic location where the trip begins and a different location whree the trip ends). These is what I'm working with:

TRIP_ID	START_PLAC  END_PLACE  START_TIME   END_TIME        	
2686005	YLpAlt	       StrkMa            1221	  1331
2686014	MaImPr	       BrMlLZ            0609	  0736
2686015	YLpAlt	       StrkMa            0605	  0704
2686016	MaImPr	       StrkMa            0627	  0718
2686017	MaImPr	       BrMlLZ            0637	  0811

I want to somehow chain together trips that have matching start and end places, for example if a trip ends at YLpAlt... group that trip with another trip that starts at YLpAlt. Then from there take the next step and group those two with another trip or another two trips that have common start and end places. I thought the DLOOKUP function might apply here but I'm not exactly sure how. Any thoughts on how I would start to go about this?

Thanks in advance.

[NeoPa]

This depends very much on exactly what you mean by "group that trip with ..."?

Are you expecting to change data? Display it differently? What if there is more than one matching option?