One to many

[rjm13]

Hi all,

I have two tables I am working with, a Course table and a Targeted Audience table ONE to MANY. In the many table I have a foreign key field and a TargetAudience field. Can anyone think of a way to query this where I end up with one row for each courseID and the values from the targetedAudience field combined into one field which is comma (,) delimitted. I'm having major problems with this, any help is greatly appreciated.

Thanks,

R

 

[lespaul]

check out FAQ701-4233

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[rjm13]

That works! thanks Leslie... are you a guitar player? (lespaul)

Thanks again,R

 

[lespaul]

no, but you're not the first to ask!

 

[dhookom]

Actually Leslie is a keyboardist ;-)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lespaul]

Thanks for starting my day with a laugh!

les