Concantenate - another level

[Griff]

I have used Duane Hookum's concantenate code in a query - it works great!
However, I need to modify it to fit my database application.

In my database, tblFamMem.FirstName is a number, which is linked to a lookup
table with NameID and NameText. I want to be able to concantenate the
NameText field.

The Concantenate code works with a one-to-many relationship, but this is a
many-to-one relationship and I can't get it to work.

Thanks in advance,

Griff.

 

[Jeff Boyce]

Griff

It sounds like you may be trying to work directly against the tables.

Have you looked into creating queries to gather-together what you need/want?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

It should work. Can you post the arguments to the Concatenate function
that you are using? Also tell us which table id the many side and which
fields are used to relate the two tables.





'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Griff]

Thanks Jeff;

That did the trick - I used a query to gather the relevant information and
concantenated based on that.

Thanks for your help.

Griff