Table Join

  • Thread starter Thread starter Chris Brotz
  • Start date Start date
C

Chris Brotz

I am trying to join two tables in a query. The first table has the key and
the second table can have one or multiple descriptive lines. I want all the
description, but do not want it to repeat the records from the first
table....I have an example below:

Table 1 Table 2 Class # Description

12000 John Doe 12000 300 Accounting
12000 301 Accounting
Assistant

Is there a way to join these in one record without creating separate tables
for each description?

Thanks for your help!
 
Thanks for the feedback.....This code is a bit over my head. I passed it on
to our IS staff to interpret. I was looking for a function I could use in a
criteria statement or in an expression right in the query window....This
looks like a function I would need written behind the scene?

Chris
 
Back
Top