By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

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

luvgis
P: 12
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_Place" 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:
Expand|Select|Wrap|Line Numbers
  1. TRIP_ID    START_PLAC  END_PLACE  START_TIME   END_TIME            
  2. 2686005    YLpAlt           StrkMa            1221      1331
  3. 2686014    MaImPr           BrMlLZ            0609      0736
  4. 2686015    YLpAlt           StrkMa            0605      0704
  5. 2686016    MaImPr           StrkMa            0627      0718
  6. 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.
Aug 6 '08 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,602
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?
Aug 6 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.