Okay I think I figured out part of this:
I have two tables,
tblUsers with two fields, one field is UsrIDs and one field is
UsrEmail. UsrIDs is my Primary Key in this table.
tblGroups with three fields, a Primary Key assigned automatically by
Access, field - GrpFullName and field - GrpOwner
There is one UsrID for many GrpIDs. I have joined them under
relationships with a one to many. I am trying to get a query back with
one UsrID in one column and a concatenated GrpIDs in the second column.
When I try and run an expression with the fconcat, I get a blank return
in the expression field. I am using the fconcat I read about from Dev
Ashish,
with the following replacements.
fConcatChild("t blGroups","UsrI Ds","GrpFullNam e","Char",10255 )
What am I doing wrong? I have tried Long instead of Char, but it is a
text field.
I have two tables,
tblUsers with two fields, one field is UsrIDs and one field is
UsrEmail. UsrIDs is my Primary Key in this table.
tblGroups with three fields, a Primary Key assigned automatically by
Access, field - GrpFullName and field - GrpOwner
There is one UsrID for many GrpIDs. I have joined them under
relationships with a one to many. I am trying to get a query back with
one UsrID in one column and a concatenated GrpIDs in the second column.
When I try and run an expression with the fconcat, I get a blank return
in the expression field. I am using the fconcat I read about from Dev
Ashish,
with the following replacements.
fConcatChild("t blGroups","UsrI Ds","GrpFullNam e","Char",10255 )
What am I doing wrong? I have tried Long instead of Char, but it is a
text field.